Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ JDBC Driver GuideThe HCL OneDB™ JDBC Driver Programmer's Guide describes how to install, load, and use HCL OneDB™ JDBC Driver to connect to the HCL OneDB™ database from within a Java™ application.
Globalization and date formats
Support for code-set conversion
Connect to a database with non-ASCII characters

Connect to a database with non-ASCII characters

If you do not specify the database name at connection time, the connection must be opened with the correct DB_LOCALE value for the specified database.

If close database and database dbname statements are issued, the connection continues to use the original DB_LOCALE value to interpret the database name. If the DB_LOCALE value of the new database does not match, an error is returned. In this case, the client program must close and reopen the connection with the correct DB_LOCALE value for the new database.

If you supply the database name at connection time, the DB_LOCALE value must be set to the correct database locale.

You can connect to an NLS database by defining a locale with NEWCODESET and NEWLOCALE connection properties. For information about their formats, see Connecting with the NEWLOCALE and NEWCODESET Environment Variables .