Re: error: Non Supported Character Set

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 21 Jun 2002 14:21:07 -0700
Message-ID: <336da121.0206211321.12679d6e@posting.google.com>

"Kenny Yu" <kyu_at_biodiscovery.com> wrote in message news:<uh4lsv5ih1m097_at_corp.supernews.com>...
> My ora 9i was up and running on win2k server. But a jdbc connection to it
> returns message
> Non Supported Character Set: oracle-character-set-178
> ORA-17056
> I found no further docs on this error message
>
> The same java program runs fine when connected to another ora 9i on linux.
>
> Any idea what is wrong?
>
> Kenny

What kind of jdbc driver are you using? Looks like it's thin, in this case:

Check ORA_NLS variable in the registry. It should be set to %ORACLE_HOME%\ocommon\nls\admin\data.

Also check if you can use UTF8 characterset on server:

select convert('abcd', 'WE8ISO8859P1', 'UTF8') from dual;

If I remember it right, thin jdbc causes Oracle server to convert characters to
UTF8 as intermediate characterset. I can be wrong, you can find better info on
OTN. Received on Fri Jun 21 2002 - 16:21:07 CDT