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 number
IC83702
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B70
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-05-23
Closed date
2012-10-30
Last modified date
2024-09-24
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 September 2024