Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
GLS User's GuideThese topics describe the Global Language Support (GLS) feature available in HCL® OneDB® products.The HCL OneDB™ GLS User's Guide describes the Global Language Support (GLS) feature available in HCL® OneDB® products.
SQL featuresThese topics explain how the GLS feature affects the HCL® OneDB® implementation of SQL.
Locale-sensitive data typesThese topics explain how a locale affects the way that a database server handles the MONEY data type, extended data types, and smart large objects (CLOB and BLOB data types).
Handle the MONEY data typeThe MONEY data type stores currency amounts. This data type stores fixed-point decimal numbers up to a maximum of 32 significant digits. You can specify MONEY columns in data definition statements such as CREATE TABLE and ALTER TABLE.

Handle the MONEY data type

The MONEY data type stores currency amounts. This data type stores fixed-point decimal numbers up to a maximum of 32 significant digits. You can specify MONEY columns in data definition statements such as CREATE TABLE and ALTER TABLE.

The choice of locale affects monetary data in the following ways:

The default value of scale in the declaration of MONEY columns
The currency notation that the client application uses

The locale defines the default scale and currency notation in the MONETARY category of the locale file. For information about the MONETARY category of the locale file, see The MONETARY category.