Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Storing Chinese in Oracle Database

user513543Dec 8 2006 — edited Dec 9 2006

Hi all,

I have a doubt in storing Chinese fonts in my oracle database.

The server setup is as follows.

OS- windows 2000 server
RDBMS - ORACLE 8I (8.1.7)

nls_parameters -

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET WE8ISO8859P1

The CLIENT setup is as follows:

OS - windows XP/2000 professional (English version)

The main requirement is,only two fields or some specific fields of a table should allow chinese fonts to get stored in the oracle database.

i need to know what are the changes i have to do on server side such as changing the CHARACTERSET , NLS_NCHAR_CHARACTERSET parameters and on the client side such as setting nls_char etc...

Thanks & regards,

Ashok Kumar.G

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2007

Added on Dec 8 2006

#database-key-features, #database-mobile-server-inc-legacy-database-lite

3 comments

4,959 views