0

I am running MariaDB 10.4. I am trying to setup symmetricDS for database syncing. Some of the tables it creates have fields that are are VARCHAR(255). I know UTF8mb4 can only support up to VARCHAR(191)

I know I can setup my database to be UTF8 and this problem goes away. But it is my understanding that is not ideal solution. I can't change the tables/fields that symmetricDS is creating.

I have read some other posts about this, since there are many. But haven't seen anything above MariaDB 10.2 which I believe I read that things have changed with the engines past 10.2. So I just want to see if it is all still relevant.

Is there any way this can be resolved, while staying with UTF8mb4? Or does it even matter and just go to UTF8?

Improve this question
2

1 Answer 1

Reset to default
1

I'd keep the utf8mb4 as the default.

You can use innodb_large_prefix=1 to get past the index length limitation.

Its also quite possible that symmetricDS doesn't actually need 255 length character field and its just a length for arbitrary default reasons.

Improve this answer
1
  • 1
    That Variable is deprecated in 10.3.13 and removed from 8.0.0.
    – Rick James
    Commented Apr 29, 2020 at 4:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.