Re: NLS_LANG Setting

From: Winnie Liu <poohland_at_hotmail.com>
Date: Wed, 8 Jul 1998 22:17:15 -0700
Message-ID: <6o1jgv$p6j@sjx-ixn2.ix.netcom.com>

The chinese character is multi-byte character set while the American character type is single-byte character. There is no way to see or store multi-byte character using single-byte character server. The single-byte character server will not recognize any of those multibyte chinese character.

Winnie Liu

Scarlett Yu wrote in message ...
>Hello,
>I have installed the Oracle8 client for Win NT and set the NLS_LANG to:
>TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5. The server is in Unix platform and
>the Oracle8 Server is set to:AMERICAN_AMERICA.US7ASCII.
> The problem is when I insert data, which are Chinese Character,
>into the Oracle database through 'Oracle ODBC 32Bit Test', all the Chinese
>Character become unknown symbol and Question mark(?). Can anyone know how
>to soft this problem?
>
>And I try the SQL statement in client side:
> select userenv('LANGUAGE') from dual
>the result is:
> TRADITIONAL CHINESE_TAIWAN.US7ASCII
>instead of:
> TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5
>Why they are different??? and How to soft this problem???
>Thanks for your attention!
>
>Regards,
>Scarlett
>
Received on Thu Jul 09 1998 - 00:17:15 CDT