[laurince]

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

[laurince]

Ritesh wrote on Nov 25 2004, 01:46 PM:

It is because we are now using a new client library.

We are working on this issue and plan to fix it in 4.1.

Expecting for that!

My server & encoding are mysql-win32-5.0.2-alpha, utf-8,

Chinese characters (sure stored properly) are displayed as “???” in the client,

I suggest that the connection has a property charset_client/…

which is customizable to specify our own encoding.

Regards

Roger

[Author]

Posts