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.

Collation order in SELECT statements

The SELECT statement performs a query and collation can affect the order of parts of the SELECT statement.

Collation order affects the following parts of the SELECT statement:

The ORDER BY clause
The relational, BETWEEN, and IN operators of the WHERE clause
The MATCHES and LIKE conditions of the WHERE clause

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.