Re: why client characterset and sever characterset are set to Latin when character set client and server are set to different character set

[Sam Ohn]

Hi Rick. Thank you for your answer again.

I thought it could be a bug or a problem of STATUS command. But, a real problem is that Japanese character saved in utf-8 corrupted and I have already spent one week to solve this problem.


> Do you have any character set problems?
Not as I know. If I use SJIS for data, database, and client, I don't get the same issue.

> Do you execute SET NAMES utf8 after connecting?
Yes.

> Were you connected as root (or other SUPER user)
Yes.

Also, in my.ini file I set utf as default character for server and client:

[mysqld]
default-character-set=utf8
…
[mysql]
default-character-set=utf8
…

Rick James Wrote:
-------------------------------------------------------
> Well, perhaps STATUS is misleading.
> Do you have any character set problems?
> Do you execute SET NAMES utf8 after connecting?
> Were you connected as root (or other SUPER user)