[Phpmyadmin-devel] charset question
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. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
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=DEVDEV
------------------------------------------------------------------------
_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
participants (2)
-
Marc Delisle -
Michal Čihař