Corrupt Chinese characters are displayed in a DataWindow

Chinese characters can be entered into a DataWindow and updated to a SAP ASA/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 ASA/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 Appeon Server is the same as that of the SAP ASA/SQL Anywhere database computer.