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.
Data definition statementsHCL OneDB™ supports a configuration parameter, SQL_LOGICAL_CHAR, whose setting can simplify the use of certain Data Definition Language (DDL) statements of SQL when you declare character data types in locales that support multibyte code sets.
Automatic resizing of the expansion factorWhen SQL_LOGICAL_CHAR is set to a valid digit, and the current session creates a database, HCL OneDB™ compares the SQL_LOGICAL_CHAR value with the maximum number of bytes that any logical character requires in the code set of the database locale.

Automatic resizing of the expansion factor

When SQL_LOGICAL_CHAR is set to a valid digit, and the current session creates a database, HCL OneDB™ compares the SQL_LOGICAL_CHAR value with the maximum number of bytes that any logical character requires in the code set of the database locale.

If the SQL_LOGICAL_CHAR setting is greater than that maximum number of bytes, the database uses the maximum value for the locale as the new expansion factor, overriding what the configuration file specifies. The SQL_LOGICAL_CHAR setting in the configuration file remains unchanged, and continues to act as the default expansion factor for the creation of other databases.