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 Informix® GLS User's Guide.