Hi,
About this bug report (moved by me to support).
I don't understand what he means by "a latin1_swedish_ci field that holds data which represents windows-1251 characters".
The test he suggests today works as he says. I used Windows's charmap to choose the cyrillic character O with a vertical bar (represented here http://en.wikipedia.org/wiki/Cyrillic_alphabet by value 424). I inserted this character via a small application as he suggests. With the small application (forcing a windows-1251 charset) I see the character correctly. In phpMyAdmin, using an hex transformation, phpMyAdmin 2.8.2 displays c3 b4. Without a transformation, it's not the right character.
Can someone explain me what is this c3 b4?
Because in win 1251 http://en.wikipedia.org/wiki/CP1251 this O vertical bar character should be D4.
Note: In the thread I made a test with what I think is the proper way of inserting cyrillic characters.
Marc
Hi
Looks to me like usual charset problem with MySQL > 4.1.
On Wed, 19 Jul 2006 09:03:31 -0400 Marc Delisle Marc.Delisle@cegepsherbrooke.qc.ca wrote:
I don't understand what he means by "a latin1_swedish_ci field that holds data which represents windows-1251 characters".
You have latin1 column and connection and write to it windows-1251 char. As long as you use same connection, char is returned same and no MySQL conversion is done.
The test he suggests today works as he says. I used Windows's charmap to choose the cyrillic character O with a vertical bar (represented here http://en.wikipedia.org/wiki/Cyrillic_alphabet by value 424). I inserted this character via a small application as he suggests. With the small application (forcing a windows-1251 charset) I see the character correctly. In phpMyAdmin, using an hex transformation, phpMyAdmin 2.8.2 displays c3 b4. Without a transformation, it's not the right character.
Can someone explain me what is this c3 b4?
He wrote \xd4 to database in latin1, we read it at utf-8, so MySQL has to convert _latin1_ \xd4 to utf-8 what is surprisingly \xc3\xb4.
The problem is that actual charset he uses is different than he tells to MySQL.
Thanks Michal, and Sebastian (in the support thread).
Marc
Michal Čihař a écrit :
Hi
Looks to me like usual charset problem with MySQL > 4.1.
On Wed, 19 Jul 2006 09:03:31 -0400 Marc Delisle Marc.Delisle@cegepsherbrooke.qc.ca wrote:
I don't understand what he means by "a latin1_swedish_ci field that holds data which represents windows-1251 characters".
You have latin1 column and connection and write to it windows-1251 char. As long as you use same connection, char is returned same and no MySQL conversion is done.
The test he suggests today works as he says. I used Windows's charmap to choose the cyrillic character O with a vertical bar (represented here http://en.wikipedia.org/wiki/Cyrillic_alphabet by value 424). I inserted this character via a small application as he suggests. With the small application (forcing a windows-1251 charset) I see the character correctly. In phpMyAdmin, using an hex transformation, phpMyAdmin 2.8.2 displays c3 b4. Without a transformation, it's not the right character.
Can someone explain me what is this c3 b4?
He wrote \xd4 to database in latin1, we read it at utf-8, so MySQL has to convert _latin1_ \xd4 to utf-8 what is surprisingly \xc3\xb4.
The problem is that actual charset he uses is different than he tells to MySQL.
Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=D...
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-
Marc Delisle -
Michal Čihař