|iNTERFACEWARE Products Manual > Installing and Using Iguana > Working With a Database > Database Troubleshooting > Oracle Character Set Conversion Issues|
This solution shows you how to resolve a common Oracle character set conversion issue in Iguana. It is intended for users who are:
For messages being transmitted from an Oracle database to an LLP client, you may encounter an issue where special characters are being incorrectly converted to "?" or other types, even if they have been inserted into the tables correctly.
To correct this issue, you must get your instant client to connect to the correct character set for the database, otherwise a different character set will be used when inserting data. On Windows you must set an NLS_LANG registry subkey for each of your Oracle homes using the Windows Registry Editor.
To set the NLS_LANG registry subkeys:
Below you will find an example of how to set the NLS_LANG value for Oracle 9i: