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

[Andreas Becker]

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.
>
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english