Re: cannot change character set
Posted by: Rick James
Date: June 26, 2010 01:30PM

I mentioned SHOW COLLATION because it also lists the possible charset.

phpmyadmin and the commandline tool (mysql) could well be defaulting differently.

Will ADO.NET let you do SET commands? If so, set the three session variables that comprise SET NAMES utf8.

Something is removing the accents. I believe it is either
* something other than mysql, or
* Mysql, but because of incorrect settings.

Possibly related (to Hungarian):
http://forums.mysql.com/read.php?10,367170 (joined query problem)
http://forums.mysql.com/read.php?10,291431 (Slow retreieve under MyIsam)
http://forums.mysql.com/read.php?10,288177 (UTF-8 problem)
http://forums.mysql.com/read.php?20,287941 (trying to move a database from mysql 4.0.18 to 5.0.77)
http://forums.mysql.com/read.php?24,39066 (Server just hanging (Copying to tmp table))

It should be possible to put the 3 settings in my.cnf. (Sorry, I don't the exact syntax.)

http://en.wikipedia.org/wiki/Double_acute_accent
shows 0xD5 0xF5 (iso upper/lower)
http://www.fileformat.info/info/charset/UTF-8/list.htm
shows c590 / c591 (utf8)
http://www.fileformat.info/info/unicode/char/0150/index.htm (or 0151)
details several representations

This says (to me) that the character is correctly represented in utf8 in the table:
Language3 HEX(Language3) LENGTH(Language3) CHAR_LENGTH(Language3)
ő C591 2 1

The 6f says that the character got converted going _into_ the table. Or it was de-accented even before handing to mysql.

I really wish I could say "do ___ to make your characters work right". But I keep running into situations that lead away from a simple answer. (Such as phpmyadmin vs commandline.)

Options: ReplyQuote


Subject
Views
Written By
Posted
6507
June 09, 2010 12:51PM
2775
June 13, 2010 09:44PM
8229
June 21, 2010 08:25AM
2845
June 23, 2010 11:37PM
4277
June 25, 2010 07:46AM
Re: cannot change character set
3888
June 26, 2010 01:30PM


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.