Re: How to shows Chinese?

Yes. You bet is bingo. I remember that I selected ZHT16BIG5 which is a Chinese character set just only on National Language option while database was building and its main language was remain US7ASCII. So I can see ZHT16BIG5 from NLS_NCHAR_CHARACTERSET parameter in nls_database_parameters. And of cause, the NLS_TERRITORY and NLS_LANGUAGE are both in america setting.

Would you simply to discribe what are the difference between two language setting and, how to use NLS_NCHAR_CHARACTERSET if I can so that avoid the database altering.

--
Best regards,
Diviner.

sybrandb_at_my-deja.com wrote:



> In article <3A4ADAA0.597D181A_at_hknet.com>,

>   Diviner <diviner_at_hknet.com> wrote:

> > 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.

> >

> >

> Verify the character set of your database by issuing select * from

> nls_database_parameters or select * from sys.props$.

> My bets are it will list US7ASCII. If that's true you need to change

> the character set of the database. Refer to the alter database command

> on how to do this.

>


> Regards

> --

> Sybrand Bakker, Oracle DBA

>


> All standard disclaimers apply

> ------------------------------------------------------------------------

>


> Sent via Deja.com

> http://www.deja.com/