[TYPO3] UTF-8 and STATIC_LANGUAGES/sr_language/menu

[ries van Twisk]

Please don't post the same message with two different subjects.

One possible problem is that you follow instructions on http://www.typo3-media.com/blog/article/utf8-and-typo3-updated.html
On the section 'Change Charset in an existing project'
It instructs you to RECODE your SQL dump, this is NOT needed for  
resent versions of MySQL dump
because it already dumps in UTF-8 by default.

On the question :
First, where is this table and why doesn't it get dumped when I do a
"mysqldump"?

You need to ask the MySQL folks, it should get dumped, the
question could also be 'Why didn't it restore... so check your dump and
see if the tables are in there'. I truely hope all tables and data
is in the dump.

Ries



On Dec 18, 2007, at 10:45 PM, richmahn wrote:

>
> Hi all,
>
> 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/UTF-8-and-STATIC_LANGUAGES-sr_language-menu-tp14359436p14359436.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

--
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