Connect with the NEWNLSMAP environment variable

To support connecting to NLS databases, HCL OneDB™ JDBC Driver maintains a table for mapping NLS locale to the corresponding Java™ development kit locale and code set. Locales and code sets that are not supported in a particular version of the development kit might be supported in later versions of the development kit. Use the NEWNLSMAP connection property to specify mappings for an NLS locale that is not specified in the table.

The NEWNLSMAP property has the following format:

NEWNLSMAP=NLS-locale,JDK-locale,JDK-codeset:NLS-locale,JDK-locale,
JDK-codeset,....

Here is an example URL using these properties:

jdbc:informix-sqli://myhost:1533:informixserver=myserver;

user=myname;password=mypasswd;NEWNLSMAP=rumanian,ro_RO,ISO8859_2;

There is no limit to the number of mappings you can specify. If you specify an incorrect number of parameters or values, you get a Locale Not Supported or Encoding or Code Set Not Supported message.