Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Compose SELECT statements
SELECT statement overview
Output from SELECT statements
Output in non-default code sets

Output in non-default code sets

You can issue a SELECT statement that queries NCHAR columns instead of CHAR columns or NVARCHAR columns instead of VARCHAR columns.

For more Global Language Support (GLS) information, see the HCL OneDB™ GLS User's Guide. For additional information on using NCHAR and NVARCHAR data types with non-default code sets, see the HCL OneDB Database Design and Implementation Guide and the HCL OneDB Guide to SQL: Reference.