[TYPO3] Unicode (UTF-8) and SQL question(s)

[Irina Grimpe-Lishchenko]

Try first only to force Typo3 to use UTF-8. I work with multilanguage 
sites too and I have noticed that  UTF8 in Typo3 has nothing to do with 
collation of  MzSQL database.  Typo3 converts symbols internally, so 
that it will work independantly on MySQL database

When I am wrong in mz understanding of question, let me know  that :)

Irina Grimpe-Lishchenko

>Hi,
>
> 
>
>I need to change my web page a little as I have 3 different languages on and
>one of them is Latvian, which contains many non English characters.
>Especially the title bar looks nasty as all the special characters are
>displayed as e.g Īrija instead of the real word for Ireland in Latvian.
>
> 
>
>I figured out, that I need to force Typo3 to use UTF-8 and I also need to
>change my SQL database to use UFT8_unicode_ci.
>
> 
>
>Do I need to change every single collation from whatever it is today to
>UFT8_unicode_ci or just those where special characters will appear?
>
> 
>
>If so, is there an easy way to do it? Like SQL query.
>
> 
>
>Specs:
>
>Typo3 3.8
>
>TV 0.4.0
>
>MySQL 4.1
>
> 
>
>Any tip appreciated
>
> 
>
>Jack 
>
>_______________________________________________
>TYPO3-english mailing list
>TYPO3-english at lists.netfielders.de
>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>
>  
>