[TYPO3] utf-8 to show up correctly not only in FE/BE but in mysql clients, too?

Jozef Uhliarik uhliarik_jozef at ztsnam.sk
Mon Mar 12 11:18:20 CET 2007


And what with old data in the database?

"Thomas Kieslich" <thomas at tk-studio.de> pí¹e v diskusním pøíspìvku 
news:mailman.1.1173687083.6503.typo3-english at lists.netfielders.de...
> Hi
> Try to set this on the beginning of localconf.php
>
> $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8';
>
> This should be work for new Entries in the Database.
>
> Thomas
>
>
> Am Mon, 12 Mar 2007 03:50:26 +0200 schrieb Giannis Economou:
>
>> Hello,
>>
>> just a question about storage of characters into db (using MySQL
>> 4.1.20). Looking into the database tables, greek strings are not
>> viewable when using the command line mysql client or phpmyadmin. I'm
>> seeing strings like: Î'Î?Î?ÎoÎ?Î1Î?I®IfÎ?Î1I,
>>
>> Everything shows up fine in FE and BE.
>>
>> How can I have both right? (FE/BE to show correct characters and
>> phpmyadmin or mysql client to show correct utf-8 strings). Database and
>> tables were created with  DEFAULT CHARSET=utf8.
>>
>> Thank you,
>> Giannis Economou 




More information about the TYPO3-english mailing list