SAP Knowledge Base Article - Preview

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)


SAP SQL Anywhere all versions ; SAP SQL Anywhere, cloud edition all versions ; SQL Anywhere all versions


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.