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.
GLS fundamentalsThe Global Language Support (GLS) feature lets HCL® OneDB® products handle different languages, cultural conventions, and code sets for Asian, African, European, Latin American, and Middle Eastern countries.
Character-representation conventionsThe examples in this documentation use ASCII characters to represent both single-byte and multibyte characters. Multibyte characters are usually ideographic (such as Chinese characters). Multibyte and single-byte characters are represented abstractly.
Trailing white space charactersCombinations of characters with white space can occur in quoted strings, in CHAR columns that contain fewer characters than the declared column length, and in other contexts.

Trailing white space characters

Combinations of characters with white space can occur in quoted strings, in CHAR columns that contain fewer characters than the declared column length, and in other contexts.

For example, if a CHAR(5) column in a single-byte code set contains three characters, the string is padded with two white spaces so that its length is equal to the column length:

abcss

The next example represents a string of five characters (three characters of data and two trailing white space characters) in a multibyte code set where each of the data characters and white space characters consists of 2 bytes:

A¹A²B¹B²C¹C²s¹s²s¹s²

In some locales, a string can contain both single-byte and multibyte white space characters. For example, consider the following string:

abcss¹s²sss¹s²

The string has three single-byte characters (abc), a single-byte white space character (s), a multibyte white space character (s¹s²), two single-byte white space characters (ss), and one multibyte white space character (s¹s²).

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.