IC83702: NCHAR/NVARCHAR COLLATION WRONG WITH ESTONIAN LOCALE (ET_EE.UTF8)

APAR status

• Closed as program error.

Error description

• If you have a database with an estonian locale (et_ee.utf8) the
  collation order of a nchar/nvarchar string is wrong.
  
  It is:
  
  Opera
  Socrates
  Umlaut
  Vietnam
  Zebra
  
  But it should be:
  
  Opera
  Socrates
  Zebra
  Umlaut
  Vietnam
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Problem occurs on all platforms and affects all users        *
  * running reproductions similar to that provided.              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Collation is wrong on the Estonian locale (UTF-8)            *
  * (DB_LOCALE=et_ee.utf8). This can be fixed by setting         *
  * GL_USEGLU=1 and using the ICU but the customer feels this    *
  * not satisfactory as they get 'odd errors' and lower          *
  * performance.                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Submit patch to this customer (support) -- for general users *
  * this fix will be included in GLS 6.00.                       *
  ****************************************************************
  

Problem conclusion

• I have implemented character orderings that conform to UCA
  (Unicode Collation Algorithm) so now the collations should be
  nearly identical/congruent (except for where NCHAR columns are
  having their ordering messed up by our use of space padding..
  but that is another bug for another time..).
  
  I implemented this as a brand new locale for now
  (DB_LOCALE=et_ee.utf8@ucal)
  

Temporary fix

Comments

• http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp
  http://www.ibm.com/support/fixcentral
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels