The ODBC environment variable II_ODBC_WCHAR_SIZE overrides the default byte size of Unicode characters for the ODBC Driver.

Applications that use unixODBC on Linux or UNIX can define Unicode characters with a different byte size than the ODBC Driver does. Depending on the environment, the unixODBC Driver Manager can define Unicode characters with a size of two bytes, but the ODBC Driver can define Unicode characters as four bytes. For these cases, enter this command at the command prompt:

This specification forces the ODBC Driver to treat Unicode characters as two bytes instead of four.

Applications that use DataDirect define Unicode characters with only one byte, but the ODBC Driver defines Unicode characters as two or four bytes. DataDirect environments use only UTF-8 encoding. To make the ODBC Driver compatible with DataDirect, execute these commands from the command prompt:

where the xx is the instance ID. 

II_ODBC_WCHAR_SIZE can also be set in the config.dat file. For example, issue the following command to specify the setting for the machine myhost:

or: