Symptom
- The data in the table is Thai character.
- There are 2 similar rows in the table, but they are a bit different as shown below:
the 1st row has "ศุภมาศบ้านและที่ดิน" ------- "บ้าน"
the 2nd rowhas "ศุภมาศบ้่านและที่ดิน" ------- "บ้่าน"
- Creating unique index on this column fails with the following error:
Msg 1505, Level 16, State 2:
Server 'Thai', Line 1:
Create unique index aborted on duplicate key. Primary key is '"ศุภมาศบ้่านและที่ดิน"'
Read more...
Environment
-
SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL02 and higher
- Dataserver
- Solaris on Sparc 64bit
- Solaris x86_64 64bit
Product
SAP Adaptive Server Enterprise 16.0
Keywords
thaidict, utf8, charset, CR800715, CR#800715, 800715 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.