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.
Problem with special characters
-
garvinhicking
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Problem with special characters
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
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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/