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.