Hi all,
Thanks to shardow for the tip! Now I can read and write Chinese into MySQL DB properly
through SQLyog! but, only specify character_set_connection is not enough, also
character_set_results and character_set_client need be set to the same value, and the
same to the system locale.
for MySQL v4.1.8, the three can be combined into one, just set names ${platform_charset}
then everything is OK! (don't know about other db servers).
so I think in later version of SQLyog, it can call set names xxx when establishing a connection
and xxx defaults to system locale, anyway, it should be customizable.
thanks to all.
Regards