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

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

Symptom

  • 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

Read more...

Environment

  • 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)

Product

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

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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