Re: why client characterset and sever characterset are set to Latin when character set client and server are set to different character set
Posted by: Sam Ohn
Date: November 13, 2010 11:46AM

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)

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.