Symptom
- When querying a CHAR / VARCHAR / LONG VARCHAR / NCHAR / NVARCHAR / LONG NVARCHAR column in a SELECT statement with a LIKE predicate, incorrect results may be returned.
- The column uses the Unicode Collation Algorithm (UCA) as its collation sequence, with either the 'CaseSensitivity=Respect' or 'AccentSensitivity=Respect' options.
- The column has a descending index defined on the column.
- The LIKE predicate starts with a prefix of non-wildcard characters.
Read more...
Environment
- SAP Sybase SQL Anywhere 10
- SAP Sybase SQL Anywhere 11
Product
Sybase SQL Anywhere 10.0 ; Sybase SQL Anywhere 11.0
Keywords
11495821 , 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.