How to resolve SQL Anywhere charset issue

[Former Member]

In my application, when mobilink synchronize data between consolidate database and remote database, there is an error message as below:

I. 2018-11-02 09:57:16. <2> COMMIT Transaction: Prepare for download E. 2018-11-02 09:58:16. <2> [-10211] A downloaded value for table 'R021_PRD_DESC' (column #3) contains character data that cannot be converted I. 2018-11-02 09:58:16. <2> Error Context: I. 2018-11-02 09:58:16. <2> Remote ID: 354127a9-2003-456c-b08d-d8191428d1f6 I. 2018-11-02 09:58:16. <2> User Name: AY0475 I. 2018-11-02 09:58:16. <2> Modified User Name: AY0475 I. 2018-11-02 09:58:16. <2> Transaction: Download I. 2018-11-02 09:58:16. <2> Table Name: R021_PRD_DESC I. 2018-11-02 09:58:16. <2> Fetch Row: I. 2018-11-02 09:58:16. <2> 379619 I. 2018-11-02 09:58:16. <2> en_AD I. 2018-11-02 09:58:16. <2> KIT VISIBILITAâ SORRISI IN FAMIGLIA I. 2018-11-02 09:58:16. <2> MOBILINK I. 2018-11-02 09:58:16. <2> 2018-11-02 09:58:16.000000 I. 2018-11-02 09:58:16. <2> 2014-06-02 08:18:30.000000

The consolidate database is Oracle 12c and the charset is AL32UTF8

The remote database is SQL Anywhere 17

I refered this workaround - https://launchpad.support.sap.com/#/notes/2599105

The questions:

1. How to Set charset parameter to UTF8 in the ODBC driver (charset=utf8)?

2. I tried to change the column type to nvarchar, it show me the error message:

The column XXX could not be modified in the database. This operation is only allowed within a synchronization schema change.

[VolkerBarth]

Is that a different question than this one by you?