Is It Possible to Detect Server Side Encoding?

[laurince]

Hi,

I'm using SQLyog v4.0, the server is sql-win-5.0.2-alpha,

encoding of data is utf-8

in the query result list, Chinese charaters are displayed as “???”

So, the question is, is it possible to detect the serverside encoding?

or add a configuration entry to a connection that specifies the

encoding we use to connect to the server?

Regards

Roger

[Ritesh]

We plan to implement all encoding related issues in SQLyog v4.2.

[Shadow]

Try setting character_set_connection variable manually from SQL window to a Chinese charset!

[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

[Ritesh]

Great to know that SQLyog works for you 😀

As I said before, all the encoding related features will be added in SQLyog by v4.2.

[Author]

Posts