[TYPO3] UTF8 in MySQL Database with a MySQL client in latin1

Dominique Feyer dominique.feyer at reelpeek.net
Mon Aug 18 14:48:51 CEST 2008


Le 18 août 08 à 12:05, Dmitry Dulepov [typo3] a écrit :

> Hi!
>
> Dominique Feyer wrote:
>> $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;';
>>
>> If I add this line, the frontend (templavoila) loose the template
>> configuration, and in the backend all the accentuated characters as
>> trouble.
>
> Yes. MySQL starts returning data differently. TemplaVoila cannot  
> decode it anymore. You need to remap templates.
>
>> Everything work nice in the TYPO3 backend and frontend, but if I  
>> insert
>> data in the TYPO3 database with phpmyadmin or an other mysql client
>> correctly configured in UTF8, the output in TYPO3 is not good
>
> What do you mean by "correctly configured"?

I mean the client configured as UTF8 (like 'SET NAMES utf8;' for  
phpmyadmin, or UTF8 for ODBC)

>
>> When i browse my database in PHPMyAdmin, i can't see the accentuated
>> characters correctly except if I edit this record with phpmyadmin.  
>> But
>> in this case TYPO as some trouble with the accentuated characters.
>
> I guess phpMyAdmin does not make "set names utf8" automatically for  
> you. This is why you see data in the wrong way.

I see the data correctly in the typo3 backend but not in PHPMyAdmin  
(configured as UTF8) and external database tool connected over ODBC  
as UTF8

>
> -- 
> Dmitry Dulepov
> TYPO3 Core team
> My TYPO3 book: http://www.packtpub.com/typo3-extension-development/ 
> book
> In the blog: http://typo3bloke.net/post-details/ 
> typo3_code_formatting_in_eclipse/
> _______________________________________________
> 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