MySQL 3.x Character Encoding Problems
MySQL 3.x is known to have some problems upper- and lower-casing certain (non-ASCII) characters.
Diagnosing the problem
- Follow the instructions for Troubleshooting Character Encodings.
- If the upper- and lower-cased strings displayed on the Encoding Test are different, then your database is probably affected.
An example (faulty) output of the Encoding Test is shown below:
Screenshot: Encoding Test Output (excerpt)
Upgrade to a newer version of MySQL. (4.1 is confirmed to work.)