Retrieve nondefault locale information

Globalization affects the order in which lists are displayed in DB-Access. Globalization enables the display and appropriate ordering of non-English-language data. Informix® supports globalization with Global Language Support (GLS) locales. Earlier database server versions used Native Language Support (NLS) for this purpose.

If the current database supports globalization, you can select the Nls option on the DATABASE INFO menu to display information about collating sequence and C CType (character classification type), as the following figure shows.
Figure 1. The DATABASE INFO menu with globalization information displayed
DATABASE INFO:  dBspace   Nls   Routine  Databases  Exit
Display NLS information for a database.

-------------- - database_demo ------------ Press CTRL-W for Help --------

fr_fr.8859-1 Collating Sequence
DB-Access does not provide an option on the DATABASE INFO menu for displaying the GLS collating sequence and character classification type. To obtain information about the GLS locale that is enabled for your database server, enter the following query with the SQL editor:
SELECT tabname, site FROM systables
WHERE tabid = 90 OR tabid = 91
The row with tabid 90 stores the COLLATION category of the database locale. The row with tabid 91 stores the CTYPE category of the database locale. The following figure shows the result of the preceding query for the default US English locale.
Figure 2. Retrieving GLS information
SQL:   New  Run   Modify  Use-editor  Output  Choose  Save  Info  Drop  Exit
Run the current SQL statements.

------- mydata@mynewdb ------ Press CTRL-W for Help ---

tabname            GL_COLLATE
site               en_US.819

tabname            GL_CTYPE 
site               en_US.819 

2 row(s) retrieved

For further information about the COLLATION and CTYPE categories in a GLS locale file, see the HCL Informix GLS User's Guide.

Copyright© 2018 HCL Technologies Limited