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

Thomas Kieslich thomas at tk-studio.de
Mon Mar 12 14:08:39 CET 2007


Sorry for bad News
The 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


More information about the TYPO3-english mailing list