Hi All,
thanks for excellent ideas I'll start working on them right now (in a slow sunday night way). Meanwhile, I've discovered that when I do this on dev machine:
show variables like "%character%";
show variables like "%collation%";
I get this:
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
----------
collation_connection utf8_general_ci
collation_database utf8_general_ci
collation_server utf8_general_ci
And on my staging machine is this:
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 /usr/share/mysql/charsets/
------------------
collation_connection utf8_general_ci
collation_database latin1_swedish_ci
collation_server utf8_general_ci
That cannot be good. I'll play during the night and post my results in the morning.
Thanks a lot, Stepamil |