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.
A GLS localeIn a client/server environment, both the database server and the client application must know which language the data is in to be able to process the application data correctly.
Collation order for character dataCollation is the process of sorting character strings according to some order. The database server or the client application can perform collation.

Collation order for character data

Collation is the process of sorting character strings according to some order. The database server or the client application can perform collation.

The collating order affects the following tasks in SQL SELECT statements:

Logical predicates in the WHERE clause

SELECT * FROM tab1 WHERE col1 > 'bob'
SELECT * FROM tab1 WHERE site BETWEEN 'abc' AND 'xyz'

Sorted data that the ORDER BY clause creates
```
SELECT * FROM tab1 ORDER BY col1
```

Comparisons in MATCHES and LIKE clauses

SELECT * FROM tab1 WHERE col1 MATCHES 'a1*'
SELECT * FROM tab1 WHERE col1 LIKE 'dog'
SELECT * FROM tab1 WHERE col1 MATCHES 'abc[a-z]'

For more information about how the database locale can affect the SELECT statement, see Collation order in SELECT statements.

HCL OneDB™ database servers support two collation methods: