I am running MariaDB 10.4.
I am trying to configure symmetricDS for database synchronization. Some of the tables you create have fields that are VARCHAR (255). I know UTF8mb4 can only support up to VARCHAR (191)
I know that I can configure my database to be UTF8 and this problem disappears. But I understand that it is not the ideal solution. I cannot change the tables / fields that symmetricDS is creating.
I have read some other posts about this as there are many. But I have not seen anything above MariaDB 10.2 that I think I read that things have changed with engines prior to 10.2. So I just want to see if everything is still relevant.
Is there any way this can be resolved, while staying with UTF8mb4?
Or does it even matter and just go to UTF8?