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

richmahn wec at richmahn.com
Sun Dec 16 22:15:51 CET 2007


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.



More information about the TYPO3-english mailing list