Multi-byte character sets and database links

When performing the following SQL statement via a dblink we encounter a "ORA-24365: error in character conversion" error:

SELECT categorydescription
FROM sc_cat_language
WHERE languagename = 'French';

The source database executes without error if we log into it and run the query. The field contains a double-byte character specific to french, and it seems that the destination database cannot handle it.

We've tried changing the NLS_Language entry in the ORCALE.INI and the Windows registry to NLS_LANG = American_America.JA16EUC, but this hasn't helped. What needs to be set to allow Oracle to handle this?

Thanks for your help

        Marc Kazen

marc.kazen (at) compaq.com (replace the at with the @) Received on Wed Feb 18 1998 - 00:00:00 CST