1857867 - After migrating and upgrading a SQL Anywhere database, queries over strings with certain foreign characters may return an incorrect sort order

• A SELECT .... ORDER BY SQL statement is executed against a CHAR / VARCHAR / NCHAR / NVARCHAR / LONG VARCHAR / LONG NVARCHAR column with internationalized characters
• Some language characters (e.g. Cyrillic, Danish, etc.) are not sorted correctly after upgrading to a newer version of SQL Anywhere and rebuilding the older database on the newer verison.
• The correct sort order is seen when using the earlier version of SQL Anywhere (e.g. 5.0.x, 5.5.x, 6.0.x, 7.0.x, 8.0.x, 9.0.x)
• The wrong sort order is seen in the result set within current versions of SQL Anywhere (e.g. 10.0.x, 11.0.x, 12.0.x, 16.0.x, 17.0.x)
• The earlier version of the database uses a code page for its character set that is no longer supported or is the default in current versions of SQL Anywhere (e.g. Code Page 819 (CP819))
• The current version of the database uses a a different default character collation sequence or explicitly uses a different character collation sequence than the original database

• SAP SQL Anywhere 10
  SAP SQL Anywhere 11
  SAP SQL Anywhere 12
  SAP SQL Anywhere 16
  SAP SQL Anywhere 17
• Microsoft Windows (all supported platforms)

collation , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem