[TYPO3] MySQL 4.1 character set

Karsten Dambekalns karsten at typo3.org
Thu Mar 30 18:43:32 CEST 2006


Hi.

Dmitry Dulepov wrote:
>> is any solution about how to deal with character set and collations in
>> Typo3 3.8.1 somewhere? I'm struggling with it and I can't make it work.
> 
> Set it to latin1 even if you use utf-8 in the BE. Mysql handles latin1
> as "do not do any conversions".

No, please don't. Set the DB to UTF-8, set TYPO3 to UTF-8 and then tell the
connection opened by PHP to use UTF-8 as well, by entering this for
setDBinit in the install tool:
 SET CHARACTER SET UTF-8
 SET NAMES UTF-8

Karsten



More information about the TYPO3-english mailing list