[Phpmyadmin-devel] charset question

Michal Čihař michal at cihar.com
Wed Jul 19 15:19:04 CEST 2006


Looks to me like usual charset problem with MySQL > 4.1.

On Wed, 19 Jul 2006 09:03:31 -0400
Marc Delisle <Marc.Delisle at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20060719/7d403c5d/attachment.sig>

More information about the Developers mailing list