[TYPO3-english] TYPO3 and character encoding problems

Pero Peric pperic at mail.com
Wed Jul 9 17:08:44 CEST 2014


Ok finally i got it. I mean finally i understand what is going on. I 
still need to find solution, but it will be easier now. So this is 
what's happening.

As i didn't have SET NAMES utf8; defined mysql character_set_client for 
PHP was set to latin1. This resulted in this:

Character Č hex. UTF8 code is C48C. So because character_set_client was 
set to Latin1, this was not a code for UTF8 char but for Latin1 char. So 
it arrived to mysql as C48C Latin1. Because DB, table and fields were 
set to UTF8, conversion was made by mysql. C4 (what is in Latin1 hex. 
for Ä) became C384 (Ä in UTF8) and 8C (what is a control char in Latin1) 
became C28C (what is also some control char in UTF8 i suppose).

Now i suppose i just need to do conversation back to Latin1 (what will 
in fact be UTF8). Maybe to do mysqldump with --charset-output set to 
latin1 or this will not work? Any other idea? Thx.

Regards.


More information about the TYPO3-english mailing list