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

From: Georges KO <gko_at_gko.net>
Date: 28 Aug 2002 19:14:09 +0800
Message-ID: <ybybs7n1bi6.fsf@gko.net>

Georges KO <gko_at_gko.net> writes:

> Actually, what I need is really simple: transfer raw data from
> Oracle 7 to Oracle 8 only without stripping the 8th bit, in an Oracle
> job...

    I would need something like this (XX and YY are Chinese characters):

SQL> select rawtohex('XXYY') from custom_at_oracle7db

RAWTOHEX

---

A5DFB0EA SQL> select what_i_need(rawtohex('XXYY') from custom_at_oracle7db

    and what_i_need() would translate 'A5DFB0EA' back to 'XXYY', to be inserted into the column... Received on Wed Aug 28 2002 - 06:14:09 CDT