Unicode Support for Globalization
PSQL v12 SP1 includes additional support for globalization as explained in the following topics. The Advanced Operations Guide covers these features under Database Globalization.
•
NCHAR Support in PCC
•
Collation Capabilities
NCHAR Support in PCC
PSQL Control Center (PCC) now supports editing of view, procedure, and trigger body text and default column values that contain NCHAR text outside of the database code page.
Collation Capabilities
At the Btrieve level, PSQL v12 SP1 supports two new Unicode collations based on International Components for Unicode (ICU) for use with Btrieve STRING and WSTRING types. The STRING types are assumed to be encoded in UTF-8. The collation called root is the default Unicode collation defined by ICU. The collation called u54-msft_enus_0 emulates the PSQL ISR collation MSFT_ENUS01252_0 for CP1252 text when applied to UTF-8 or UTF-16 data.
For more information see Collation Support Using an ICU Unicode Collation.