New Features of Dynamic Server

The SET COLLATION statement can specify the localized collating order of a locale that is different from what DB_LOCALE specifies. This localized collation is applied to sorting operations on NCHAR and NVARCHAR data types in the same session. Database objects that sort NCHAR or NVARCHAR values use the collating order that was in effect when the object was created, if this differs from the DB_LOCALE setting.

Version 4.0 of the GLS Library, which is provided with Version 9.40 of Dynamic Server, provides the following additional new features:

• The open-source International Components for Unicode (ICU) implementation of the Unicode code set (UTF-8)
• Unicode collation, based on the ICU Unicode Collation Algorithm, in locales that use the Unicode code set
• Full support of the GB18030-2000 code set for Chinese characters

(For a comprehensive list of new Dynamic Server features in Version 9.40, see the IBM Informix: Getting Started Guide.)