Global Language Support (GLS) and Native Language Support (NLS) affect the order in which lists appear in DB–Access. GLS enables the display and appropriate ordering of non-English data. Legacy database server versions used NLS for this purpose.
If the current database supports NLS, you can select the Nls option on the DATABASE INFO menu to display information about collating sequence and C CType (character classification type), as Figure 34 shows.
DATABASE INFO: dBspace Nls Routine Databases Exit
Display NLS information for a database.
-------------- - stores_demo ------------ Press CTRL-W for Help --------
fr_fr.8859-1 Collating Sequence
CTypeAn error message displays if the database does not support NLS or the environment variables for NLS are not properly set.
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 enabled for your database server, enter the following query with the SQL editor that is described in The Query-language Option:
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. Figure 35 shows the result of the preceding query for the default U.S. English locale.
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) retrievedFor further information on the COLLATION and CTYPE categories in a GLS locale file, see the IBM Informix: GLS User's Guide.