[TYPO3-english] TYPO3 and character encoding problems

[Peter Linzenkirchner]

Hello Pero, 

try this: 

mysqldump -u USER -p --default-character-set=latin1 datenbank_name > datenbank_name.sql

open the dump in a text editor (charset utf8!) and change in SET NAMES latin1 or DEFAULT Max. CHARSET latin1  all latin1 to utf8 

then load the dump back in the database. 

this normaly fixes the problem for me. 

Peter


Am 09.07.2014 um 17:08 schrieb Pero Peric <pperic at mail.com>:

> 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.
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

--
Xing: http://www.xing.com/profile/Peter_Linzenkirchner
Web: http://www.typo3-lisardo.de
Facebook: http://tinyurl.com/lisardo-multimedia