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

[Giannis Economou]

Thank you for your reply.

Do you have any suggestions on what to try on iconv? (from chartset, to
charset)?

Regards,
Giannis



Thomas Kieslich wrote:
> Sorry for bad NewsThe existing data will not converted. Controlling utf-8 Data in Database is the first thing i do for new Projects. It depends on Typo3 and Mysql settings.There is a utf8 converter in the ExtensionsRepo. You can also try to convert a sql dump from tt_content with iconv.In most cases its quicker to make a copy of the Project, change all settings to utf-8 and copy the content from the FE of the old Project to BE of the Copy.(two Monitors recomanded)
> Thomas 
>
> Am Mon, 12 Mar 2007 13:27:15 +0200 schrieb 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_______________________________________________TYPO3-english mailing listTYPO3-english at lists.netfielders.dehttp://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>>     
>
>