Serendipity Forums

Hi all,

I have a problem with special characters. All of a sudden the German special characters are not coded in the right way anymore. It seems to be a server problem. I changed the language-files but it wasn't succesfull.
The website is: www.bib-pforzheim.de

My provider announced recently the change from MySQL 4.0 to MySQL 4.1. Could this be the reason??

It would be great if anyone could help me.

Hi!

Yes, MySQL 4.1 introduced a new charset storage method. You must use a tool like phpMyAdmin to check if your databases all have the collation of the language you are using.

When using UTF-8 as your s9y charset you must make sure that all DB tables and fields use UTF-8 as collation. If you use native charset in s9y, you must make sure that all DB tables+fields use 'de_latin1' as collation.

You might also need to enable the s9y config option "Use DBNames" in the DB section...

Best regards,
Garvin