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

  1. Follow the instructions for Troubleshooting Character Encodings.
  2. 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:

 

(warning) The information on this page does not apply to Confluence Cloud.

Screenshot: Encoding Test Output (excerpt)


 

Solution

Upgrade to a newer version of MySQL. (4.1 is confirmed to work.)

Was this helpful?

Thanks for your feedback!

Why was this unhelpful?

Have a question about this article?

See questions about this article

Powered by Confluence and Scroll Viewport