Re: hostname not set correctly on MySQL 5.6 on Korean Windows
Posted by: Rick James
Date: March 12, 2015 04:49PM

> I also discovered that if I do 'set names utf8' in my session and then do 'select @@hostname', I see Korean characters. 'show variables like hostname' still shows nothing, however.

What do you mean by "my session"? Are you using PHP? phpmyadmin? mysql commandline tool? Other?

It sounds like the display from you session is set for utf8, not euckr. And the SET NAMES is converting from euckr to utf8 on the fly.

C7D1B1B9BEEE is not utf8; I suspect it is euckr. After converting to utf8, I see 한국어; does that look correct? Here's the conversion I used (to avoid any SET NAMES, etc):
SELECT CONVERT(CONVERT(UNHEX('C7D1B1B9BEEE') USING euckr) USING utf8);

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.