4
I had the same problem on a different site. It might be the collation setting of your database. The default collation for newer versions of MySQL is latin1_swedish_ci.
Unfortunately, changing the collation is no fun. Essentially, you have to change the default collation on the database, then use the following query on every table to convert the collation. (
Make a backup first!)
ALTER TABLE <target_table> CONVERT TO CHARACTER SET latin1 COLLATE latin1_general_cs;
Change the values as needed. The above will change the values for English.
More information regarding collation can be found on
MySQL's website.
Hope this helps.
James
Insanity can be defined as "doing the same thing over and over and expecting different results."
Stupidity is not a crime. Therefore, you are free to go.
