insert chinese characters into utf8 database

[mooks]

Hi

We need to insert chinese characters into our current utf8 database. The settings as shown below :

PARAMETER VALUE
------------------------------ ------------------------------------------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET UTF8
NLS_RDBMS_VERSION 9.2.0.4.0


I tried to copy and paste the chinese character from google for testing thru sqlplus, i got "....." only! Why is this so? I have set my NLS_LANG=AMERICAN.UTF8

How do i insert chinese characters and view them correctly??

[julian]

NLS_LANG=AMERICAN.UTF8 ?

Should be: American_America.UTF8

[mooks]

I did an export NLS_LANG=AMERICAN_AMERICA.UTF8 and i login to sqlplus, but i am still getting "..." whenever i tried to paste chinese characters! Is there anything wrong with my settings?

[julian]

It doesn't work that way.

Use an UTF8 editor, WordPad for example and save the text there. Create an external table or use SQL*Loader.

[mooks]

I inserted the chinese characters thru SQL Loader. I can only view the chinese characters when i retrieved it from the database and displayed them on a browser. Can I actually view the chinese characters using a select statement from the sqlplus?

What puzzled me was that i have anotehr database using characterset US7ASCII. I loaded the chinese characters and it can be viewed thru the browser too! Therefore what is the difference between UTF8 and US7ASCII??

[julian]

You will need to use the correct NLS_LANG in the registry:

Chinese (PRC) - SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Chinese (Taiwan) - TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950

[mooks]

Thanks! I can viewed the chinese characters in the database if i activate my chinese viewer icon. Is this the right way?

[hrishy]

Originally posted by mooks
Thanks! I can viewed the chinese characters in the database if i activate my chinese viewer icon. Is this the right way?

what is a chineese viewer icon ? and what os are u on

regards
Hrishy

[mooks]

For example: NJ Star Viewer (njstar.com).
My Server OS is Redhat AS 3

Thank you!

[mooks]

Does it mean that I will always have to insert the chinese character from SQL Loader manually? No ways to insert directly into the database thru sqlplus?