How to shows Chinese?

From: Diviner <diviner_at_hknet.com>
Date: Thu, 28 Dec 2000 14:16:00 +0800
Message-ID: <3A4ADAA0.597D181A@hknet.com>

I have installed Oracle8i v8.1.6 for Linux and built a database also. I tried to
insert some Chinese character inside but can't see that from Client side.

I diagnosed my status are:
- I can insert and view Chinese very well from server side.

• I can handle Chinese from client side while through Telnet to access server.
• I checked two parameters from server, NLS_TERRITORY = "TAIWAN" NLS_LANGUAGE = "TRADITIONAL CHINESE"
• I added NLS_LANG environment variable on Client side as "TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5"
• Chinese message of sqlplus or svrmgrl from client side is work properly.

But I still can get any Chinese data are becomes confusion like:

    select name from stuff ;

    Name

---

    3/,W%A

Obviously, it is not a Chinese and even it is not a big-5 code because the string is starting by "3" which its internal code is 31 in hex. All Chinese characters starting by a character which internal code is over 127.

How to solve the problem? Thank you very much.

--
Best regards,
Diviner Chan.

Received on Thu Dec 28 2000 - 00:16:00 CST