Retrieving or inserting multibyte data using ODBC drivers displays invalid characters

[CR #550309, #550305] On Windows and Solaris, if you are executing a project using SQL Anywhere 10 ODBC drivers to retrieve multibyte data from, or insert data to, a UTF8-encoded Sybase IQ 15.0 database, the multibyte data is retrieved from the destination database as invalid characters.

Workaround: On Windows:

  1. Select Start | Settings | Control Panel | Administrative Tools | Data Sources (ODBC).

  2. Select SQL Anywhere 10 DSN name from the list of User Data Sources or System Data Sources.

  3. Click Configure.

  4. Click the Advanced tab.

  5. Enter UTF8 in the Character Set field.

  6. Click OK until you exit the ODBC Data Source Administrator window.

On Solaris:

Add “Charset=utf8” in the ODBC configuration file.