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

[David Raimosson]

Ok, let's isolate the problem further and change client to the standard MySQL Workbench instead. The final client will be a C# .NET app but I think I'll be able to solve any possible issues with that one.

Using MySQL Workbench I get the same output from "SHOW VARIABLE LIKE 'char%';" as before, except for the character_set_results:
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir C:\Program Files\MySQL\MySQL Server 5.6\share\charsets\

SELECT HEX('ø'), 'ø'; gives:
C3B8 ø

Does that help? :)