II_UNICODE_CONVERTER
II_UNICODE_CONVERTER sets the converter to be used for Unicode coercion. The DBMS Server carries out the coercion of Unicode data to local character set value based on the Unicode converter (or mapping table). Several converters are available in compiled and xml format, located in the directory $II_SYSTEM/ingres/files/ucharmaps. By default, Ingres automatically chooses the converter to use, based on the encoding used by the locale on your system.
You can manually set II_UNICODE_CONVERTER if Ingres is unable to set the converter correctly for your locale for coercing Unicode data to local character set value.
To manually set II_UNICODE_CONVERTER on UNIX based on locale
1. Type the following at the UNIX command prompt:
locale
The locale on your system is returned.
2. Use the locale value to find the character set on your system. For example, if locale is ja_JP.sjis, issue the following command:
LC_CTYPE=ja_JP.sjis locale charmap
The character set used by the system is returned.
3. Look up the character set in the file $II_SYSTEM/ingres/files/ucharmaps/charmapalias.xml. This file lists mapping IDs and their corresponding aliases. Find the mapping ID by finding the alias name value that matches the alias name. This mapping ID is the value of the converter.
4. Set the value of II_UNICODE_CONVERTER in the symbol table, as follows:
ingsetenv II_UNICODE_CONVERTER mapping_id
Recycle the server by issuing the ingstop and the ingstart commands.