[Phpmyadmin-devel] charset question

[Marc Delisle]

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 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.
> 
> 
> 
> ------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel