Re: Oracle 7 -> Oracle 8 + 8th bit problem and NLS_LANG

From: Georges Ko <gko_at_gko.net>
Date: Thu, 29 Aug 2002 06:54:48 +0800
Message-ID: <m31y8iwq4n.fsf@symbiose.dnsalias.net>

"Anurag Varma" <avdbi_at_hotmail.com> wrote:

> set nls_lang on oracle7 server to american_america.us7ascii
> ... spool out the data .. or do a direct export (This way
> .. again, I would not expect oracle to do attempt a charset
> conversion). set nls_lang on oracle8 machine to
> american_america.zht16big5 ... load the data using sqlldr ....
> or import the data.

    The problem is that the task I have to do is to synchronize between these two databases so I would need something that works in a SQL statement in a store procedure.

> * If this does not work then probably either the data in oracle7 is
> in some other charset ....

    Yeah, the data in Oracle 7 is really Big5:

SQL> select rawtohex(data) from custom_at_oracle7db

RAWTOHEX

---

A5DFB0EA     After insertion into Oracle 8, the 8th bit is stripped. I tried to convert it back to Big5 string by adding a hextoraw(), but of course, it doesn't work...

> Sorry ... I couldn't be of more help.

    Thanks for trying !

-- 
 Georges Ko (Taipei, Taiwan)      2002-08-29      gko_at_gko.net / ICQ: 8719684
               Cycle 78, year 19 (Ren-Wu), month 7 (Wu-Shen), day 21 (Ji-Si)

Received on Wed Aug 28 2002 - 17:54:48 CDT