Illegal mix of collations

[tcflam]

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!

[AlexP]

Hello,

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

[tcflam]

Hi,

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

[AlexP]

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

Code: Select all

  UniConnection.SpecificOptions.Values['UseUnicode'] := 'True';
  UniConnection.Connect;

[tcflam]

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