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(a)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=…
------------------------------------------------------------------------
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel