UsefulConcept

My new server is running BlueDragon 6.2 (free edition) connecting to MySQL through the latest ODBC drivers (3.51 I think).

I found the database was not outputing the data in UTF-8. Turns out MySQL ODBC drivers do not support UTF-8. They are working on version 5 of the drivers (why skip 4?), however that has been in Alpha since last year.

The Connector/J drivers for MySQL support UTF-8, however the free version of BlueDragon Server doesn't suport that. Other versions of BlueDragon do, however.

So bottom line: If you use BlueDragon Server Free Edition and MySQL you will not have UTF-8 until the new ODBC drivers come out, and that could be a long time.

Options:
- Use PostgreSQL instead of MySQL (or some other DB)
- Try the alpha release of ODBC drivers. Supposedly you can have both installed at the same time.
- Buy a different version of BlueDragon.

Like this entry? Subscribe to my blog.