[TYPO3] Characterset weirdness

[Dennis Cheung]

>DB collation is set to latin1.
It must be UTF8. since 4.1, mysql filter all character not exists in
the charset.

And.
patch t3lib_db youself.
add "SET character set UTF8" after mysql_pconnect (check mysql website)
and make sure all your database, tables are using UTF8 as default charset.
(I gueest using "mysql administrator" and "mysql querybrowser" to check them.

When it config correctly,
"mysql querybrowser" can view/edit all the text prefectly.


Dennis


On 2/8/06, Dmitry Dulepov <typo3 at fm-world.ru> wrote:
> Hi!
>
> Nikolas Hagelstein wrote:
> > After importing a mysqldump (import/export via shell)
> > some of the "excotic charaters" (e.g chinesse) are
> > brocken and displayed as ?? in FE/BE (notice: only a few chars are brocken,
> > not
> > all. Most of them - even the chinese ones - are displayed correctly)
>
> I can be wrong but some Chinese characters can take three or more bytes.
> I am not sure how typo3 handles this...
> --
> "It is our choices, that show what we truly are,
> far more than our abilities." (A.P.W.B.D.)
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>