SAP Knowledge Base Article - Preview

2349415 - Create unique index fails with Error 1505 due to thaidict char utf8 - SAP ASE

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.