insert chinese characters into utf8 database

Printable View

06-16-2004, 05:11 AM
mooks

insert chinese characters into utf8 database

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??
06-16-2004, 05:14 AM
julian

Re: insert chinese characters into utf8 database

NLS_LANG=AMERICAN.UTF8 ?

Should be: American_America.UTF8
06-16-2004, 05:44 AM
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? :confused:
06-16-2004, 07:18 AM
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.
06-17-2004, 12:21 AM
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?? :confused: :confused:
06-17-2004, 02:44 AM
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
06-17-2004, 04:24 AM
mooks

Thanks! :D I can viewed the chinese characters in the database if i activate my chinese viewer icon. Is this the right way?
06-17-2004, 05:09 AM
hrishy

Quote:

Originally posted by mooks
Thanks! :D 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
06-17-2004, 05:46 AM
mooks

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

Thank you!
06-17-2004, 06:20 AM
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? :confused:
06-17-2004, 06:34 AM
julian

Quote:

Originally posted by 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? :confused:

I think so. I did ask some developers and they confirmed it.