[TYPO3] Converting Typo3 database to UTF-8 leaves STATIC_LANGUAGES table still a problem

[ries van Twisk]

Be aware that if you run a newer version of MySQL you don't have
to RECODE (iconv is usually used)  a MySQL dump that was originally
in a latin character set. This is because that newer version of mysql- 
dump
already dumps in utf-8 by default!!!! I think it was a 4.1 version  
that dumps
in utf-8,and a 4.0.x dumps in latin1, I don't know details since I  
don't use MysQL to often.

However you MUST change all these latin1 crap to utf-8 mysql_dumps out.

The above might explain your double characters.

Ries

On Dec 16, 2007, at 8:09 PM, Andreas Becker wrote:

> Hi Richmahn
>
> Perhaps you just have encoded utf8 values again to be utf8 and this
> mighthave caused the jibberish.
>
> You need to check which tables might e already in utf8 before you  
> convert
> the REST to utf8.
>
> Andi
>
> 2007/12/17, richmahn <wec at richmahn.com>:
>>
>>
>> Hi,
>>
>> I have been working on getting my copy of Typo3 (lates version 4.1.3)
>> converted to UTF-8 charset in order to make a Chinese version of the
>> website.  I have followed everything at
>> http://www.typo3-media.com/blog/article/utf8-and-typo3-updated.html  
>> and am
>> now able to enter Chinese into fields successfully.
>>
>> However, using the sr_language_menu extention and the "Website  
>> Language"
>> records in the root container of my Typo3 pages, I find that now what
>> worked
>> before converting to Latin1 to UTF-8, that is, the language name  
>> from the
>> static_languages table (lg_name_local field) which once showed the  
>> name
>> for
>> Chinese language in Chinese characters (Han yu) now shows jibberish
>> characters.  I looked at my dump of my database I used when  
>> following the
>> instructions for UTF-8 conversion, and it contains no  
>> "static_languages"
>> table.
>>
>> First, where is this table and why doesn't it get dumped when I do a
>> "mysqldump"?
>>
>> Second, I am guessing now that I am reading my Typo3 database as  
>> UTF-8,
>> and
>> this table is not encoded in UTF-8, that is why everything is  
>> jibberish.
>> Does anyone know how to get this table encoded and/or  
>> sr_language_menu
>> displaying the language names correctly?  Even if I add the language
>> "Spanish", the system_languages table is used to create the  
>> language menu,
>> in which instead "Espanol" with a tilde over the "n", it gives me
>> "Español"
>>
>> Any clues on how to get sr_language_menu working with a UTF-8  
>> database
>> would
>> be most helpful!!!  Thanks.
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Converting-Typo3-database-to-UTF-8-leaves-STATIC_LANGUAGES-table-still-a-problem-tp14359374p14359374.html
>> Sent from the TYPO3 English mailing list archive at Nabble.com.
>>
>>

--
Ries van Twisk
Freelance TYPO3 Developer
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk
Phone: + 1 810-476-4193