- 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 pageThis 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.