Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Relational Operator
Support for ASCII Characters in Nondefault Code Sets (GLS)

Support for ASCII Characters in Nondefault Code Sets (GLS)

Most code sets for nondefault locales (called nondefault code sets) support the ASCII characters. In a nondefault locale, the database server uses ASCII code-set order for ASCII data in CHAR and VARCHAR expressions, if the code set supports these ASCII characters. If the current collation (as specified by DB_LOCALE or by SET COLLATION) supports a localized collating order, however, that localized order is used when the database server sorts NCHAR or NVARCHAR values.