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

    Hi,

    I have the following problem:

    On machine A, I have an Oracle 7 with NLS_LANG set to     AMERICAN_AMERICA.US7ASCII.     On machine B, I have an Oracle 8 with NLS_LANG set to     AMERICAN_AMERICA.ZHT16BIG5.     On database A, there are data encoded in Big5, that is, there are     characters with the 8th bit on.

    I would like to transfer such data from A to B:

• when I transfer them, the 8th bit is always dropped
• when I use convert(data, 'ZHT16BIG5'), most of the time, the output is '?', probably because, I guess, Oracle doesn't interpret the data of A as Chinese characters...

    What solution do I have to convert them correctly in such case?

    When I do "select data from table_at_databaseA", the 8th bit is     dropped, but when I do use "rawtohex(data)", the values over 7F     (127) are correctly displayed, so B see them...

    Any help appreciated !

    Thanks !!! Received on Tue Aug 27 2002 - 08:57:41 CDT