Re: Can't identify character set and collation used in string comparisons

[David Raimosson]

Hi!

First, I really appreciate that you take time to answer questions in this forum, it's of great value!

Second, the char% variables:
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results
character_set_server utf8
character_set_system utf8
character_sets_dir C:\Program Files\MySQL\MySQL Server 5.6\share\charsets\

Third, the SELECT HEX('ø'):
C3B8

These results are retrieved using a C# test app without specifying the charset in the connection string, using the appropriate MySQL connector.

Best regards

David