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.
Handle character dataThe GLS feature allows you to put non-ASCII characters (including multibyte characters) in the elements of an SQL statement.
Specify arguments to the TRIM functionThe TRIM function is a built-in SQL function that removes leading or trailing pad characters from character strings of 255 or fewer characters. By default, this pad character is ASCII 32, the blank space.

Specify arguments to the TRIM function

The TRIM function is a built-in SQL function that removes leading or trailing pad characters from character strings of 255 or fewer characters. By default, this pad character is ASCII 32, the blank space.

If your locale supports a code set that defines a different white space character, TRIM does not remove this locale-specific blank space from the front or back of a string. If you specify the LEADING, TRAILING, or BOTH keywords for TRIM, you can specify a different pad character.

You cannot, however, specify a non-ASCII character as a pad character, even if your locale supports a code set that defines the non-ASCII character.