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

[Giannis Economou]

Indeed my question was about the existing data. Setting

$TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8';

will not fix existing data.


Thank you,
Giannis


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