Hi,

We've just updated our software platform from CentOS 4 to CentOS 5, which entails an upgrade of MySQL from 4.1 to 5.0. After this upgrade I am unable to convert text retrieved from the database back into utf-8. The problem occurs in both Qt 4.3.5 and 4.6.0.

Details:
* The database column is varchar(100) and database is MyISAM with default charset = latin1.
* The text data is encoded in utf-8 before it's ingested into the database with the MySQL CLI.
* Querying the text in the MySQL CLI displays the correct text (arabic, hindi, etc).

On CentOS 4, with MySQL 4.1 and Qt4.x, the following code retrieves the text correctly:
Qt Code: 
  1. QTextCodec* codec = QTextCodec::codecForName("utf-8");
  2. QString name  = codec->toUnicode(query.value(1).toByteArray());
To copy to clipboard, switch view to plain text mode 
The same code on CentOS 5, with MySQL 5 and Qt 4.x returns garbled text for all non-latin1 characters. Please help.

Best regards,
John