Devart Forums

Hi all,

I use TUniQuery and statement is "call xxx(id, password)". When I open the TUniQuery, it has the following error
"illegal mix of collations (utf16_unicode_ci,implicit) and (utf8_unicode_ci,implicit) for operation '='".

I checked my database is utf8 and tables option is also utf8. How can I solve this problem?

Thanks!

Hello,

Please try to set property UseUnicode to True - and let us know the result.

Hi,

You means MySQL DB property? I set before, but fail. I will try it more detail later.

You should enable the UseUnicode option in UniConnection before connectiong to the database:

Hi, I already set it before. Anyway, I will test it again. Thanks!