Re: ORA-24329: invalid character set identifier

From: Amit <jindal_at_roguewave.com>
Date: Tue, 23 Sep 2003 17:48:27 -0600
Message-ID: <bkqpdq$hg6$1@tux.cvo.roguewave.com>

The difference is that your old Oracle server was using a ASCII characterset for NCHAR/NVARCHAR type columns and 9i is using AL16UTF16 (which is 16-bit unicode).

Do you have any setting in your environment for NLS_LANG or NLS_NCHAR ?

You can get by using the implicit translation in Oracle. You need to set NLS_LANG environment variable to something like AMERICAN_AMERICA.WE8ISO8859P1. If this alone doesn't works try also adding NLS_NCHAR variable equal to OCI_UTF16ID (I think).

Take a look at this: http://technet.oracle.com/tech/oci/htdocs/oci_faq.html

HTH

Amit Jindal, Development Engineer

Powerful, yet easy. Superior C++ database development. http://www.roguewave.com/products/sourcepro/db/

[Disclaimer: All views expressed here are my personal

views and they can be incorrect at times]

"vortex_sea" <member40260_at_dbforums.com> wrote in message news:3387849.1063920006_at_dbforums.com...
>
> Hi,
>
>
>
> I am new to this forum and also to Oracle. I have a query regarding the
> above error. I am getting this, when I try to move data from Oracle
> 8.1.7.4 (charset/NLS charset - US7ASCII/US7ASCII) to Oracle 9.2.0.3
> (charset/NLS charset - US7ASCII/AL16UTF16).
>
>
>
> Please note that I am not doing an upgrade. Please help in resolving
> this. any input appreciated.
>
>
>
> --Vortex_Sea
>
>
> --
> Posted via http://dbforums.com
Received on Tue Sep 23 2003 - 18:48:27 CDT

Re: ORA-24329: invalid character set identifier - Please help