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

What is the characterset on both databases? select * from nls_database_parameters; --- ??

Also, In the Oracle 7 database what is the datatype of the columns you are selecting from ... same question for the Oracle 8?

I might be wrong .. but don't you think you should have tried convert(data,'fromcharset','tocharset')?

Anurag

"Georges KO" <gko_at_gko.net> wrote in message news:ybyvg5w9zfu.fsf_at_gko.net...
>
> 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 - 20:47:05 CDT