Anders Ericsson wrote:
> I've installed the MySQLAdministrator 1.1. Going
> to Health->System
> Variables->SQL->Charsets I have:
>
> character_set_client utf8
> character_set_connection utf8
> character_set_database latin1
> character_set_results utf8
> character_set_server latin1
> character_set_system utf8
> collation_connection utf8_general_ci
> collation_database latin1_swedish_ci
> collation_server latin1_swedish_ci
>
> These differs from the system variables I get when
> typing SHOW VARIABLES at the MySQL command-line
> prompt. Seems strange to me.
>
No, because MySQL administrator sets them that way.
The place to start trying to rule this out is in your code. Avoid the GUI, avoid the console. Send strings to the database using the \u unicode escapes, and compare them to what you retrieve. Using your "eyes" doesn't work, because you're now dealing with multiple variables, from your console, to the operating system, to the platform encoding for the VM, to the database, etc., etc.
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html