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.
Character data typesThe locale affects the collation of built-in SQL character data types.
Localized collation of character dataThe choice of locale can affect the collating order of NCHAR and NVARCHAR character data types.
The NVARCHAR data typeThe NVARCHAR data type stores character data in a variable-length field. Data can be a string of single-byte or multibyte letters, digits, and other characters that are supported by the code set of your database locale.
Store numeric values in an NVARCHAR columnThe database server does not pad a numeric value in an NVARCHAR column with trailing blanks up to the maximum length of the column.

Store numeric values in an NVARCHAR column

The database server does not pad a numeric value in an NVARCHAR column with trailing blanks up to the maximum length of the column.

The number of digits in a numeric NVARCHAR value is the number of characters that you must store that value. For example, the database server stores a value of 1 in the mytab table when it executes the following SQL statements:

CREATE TABLE mytab (col1 NVARCHAR(10));
INSERT INTO mytab VALUES (1);