Locale-specific data formats
The format in which data appears within an application when it is in literal strings or character variables is called the end-user format. End-user formats are locale specific: different countries use different formats for numeric, monetary, date, and date/time data.
The GLS locale file defines locale-specific formats for each of
these types of data, as the following table shows.
| Type of data | Locale-file category | SQL built-in data types |
|---|---|---|
| Numeric | LC_NUMERIC | DECIMAL, INT8, INTEGER, SMALLINT, FLOAT, SMALLFLOAT |
| Monetary | LC_MONETARY | MONEY |
| Date and time | LC_TIME | DATE, DATETIME |
For more information about the end-user formats that this section describes, see the HCL Informix® GLS User's Guide.