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.
Search functions that are not case-sensitiveThe SQL search functions UPPER, LOWER, and INITCAP support GLS. They accept multibyte characters in character-type source strings and operate on them.

Search functions that are not case-sensitive

The SQL search functions UPPER, LOWER, and INITCAP support GLS. They accept multibyte characters in character-type source strings and operate on them.

The returned data type is the same as the type of the source string:

UPPER converts every letter in a string to uppercase.
LOWER converts every letter in a string to lowercase.
INITCAP changes the first letter of a word or series of words to uppercase.

For complete information about these search functions, see the HCL OneDB™ Guide to SQL: Syntax.