Illegal mix of collations for operation... MariaDB

Question

In a database where all collations are consistent, I get the following error.

Error: The field 'Row Filter' is invalid. Illegal mix of collations for operation 'in' ...

How should I resolve this error?

Answer 1

dbFront uses the MySqlConnector when connecting to any MySQL, MariaDB or similar databases.

The MySqlConnector always uses utf8mb4 to send and receive strings from MySQL Server and this is not changeable. See: MySqlConnector.

If you encounter collation errors when comparing client provided values with database provided values, then it might be appropriate to add an inline collation clause to fix this issue.

before: {[vStatus]} not in ('Abandoned', 'NoInternet', 'Tried', 'Installed')

after: {[vStatus]} not in ('Abandoned' collate utf8mb4_general_ci, 'NoInternet', 'Tried', 'Installed')

Solution: