Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi,
I have problems understanding how informix handles utf locales and specifically collations. I have a few en_us.utf8 databases but want to order by in an et_ee collation order, but not only.
The GLS manual mentions International Components for Unicode [1] however I can't figure out how to use ICU. ICU is supposedly bundled with GLS, is it not supposed to provide various utf8 locales?
ILS [2] provides an et_ee locale but that is for iso-8859-15 or -13 afaik. Or would ILS enable et_ee.utf8 too?
And where to get ILS? It's supposedly bundled with the CSDK, but not the CSDK developer edition nor the one shipped with Informix, is this true?
I also found the env variable GL_USEGLU [3] though I'm not quite sure what converting the databases does. The conversions failed with -211 and -103 on my test system. I could create a new database however could not spot the advantage of using a GL_USEGLU database.
1 - https://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.glsug.doc%2Fids_gug_029.htm
2 - https://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.glsug.doc/ids_gug_022.htm
3 - https://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.glsug.doc%2Fids_gug_090.htm
So how do I get to use an et_ee.utf8 locale/collation on my en_us.utf8 database?
Regards,
Aleksander Kamenik
System Administrator
Krediidiinfo AS
an Experian Company
Phone: +372 665 9649
Email: aleksander@krediidiinfo.ee
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.