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.
Collate character dataCollation is the process of sorting data values in columns that have character data types.
Collation order in SELECT statementsThe SELECT statement performs a query and collation can affect the order of parts of the SELECT statement.
Logical predicates in a WHERE clauseThe WHERE clause specifies search criteria and join conditions on the data that you want to select.

Logical predicates in a WHERE clause

The WHERE clause specifies search criteria and join conditions on the data that you want to select.

Collation rules affect the WHERE clause when the expressions in the condition are column expressions with character data types and the search condition is one of the following logical predicates:

Relational-operator condition
BETWEEN condition
IN condition
EXISTS and ANY conditions