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.
General SQL API features (ESQL/C)These topics explain how the GLS feature affects applications that you develop with the HCL OneDB™ Client Software Development Kit.
Handle locale-specific dataEach HCL OneDB™ SQL API product contains a processor to process source files that have embedded SQL and preprocessor statements.
Format dataWhen you globalize an application, consider how to handle the format of locale-specific data.

Format data

When you globalize an application, consider how to handle the format of locale-specific data.

The format in which numeric, monetary, and date and time data appears to the user is locale-specific. 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
Numeric	NUMERIC
Monetary	MONETARY
Date and Time	TIME

The library provides functions that allow you to perform the following tasks on locale-specific data:

Conversion changes a string that contains locale-specific format to the internal representation of its value.
You usually perform conversion on a locale-specific string to prepare it for storage in a program variable or a database column.
Formatting changes the internal representation of a value to locale-specific string.
You usually perform formatting of a locale-specific string to prepare the internal representation of a value for display to the user.