Corrupt Chinese characters are displayed in a DataWindow

Chinese characters can be entered into a DataWindow and updated to a SAP SQL Anywhere database, however, after DataWindow re-retrieve, the characters displayed are corrupt.

Cause: Chinese characters cannot be displayed correctly if the application uses a JDBC-ODBC driver for connecting to a SAP SQL Anywhere database, and the database field that contains Chinese characters is Long VarChar type.

Solution: You can use either of the two solutions below.

Change the data type of the database field from Long VarChar into VarChar.

Make sure the character set used in the operating system that runs PowerServer is the same as that of the SAP SQL Anywhere database computer.