Storing Chinese in Oracle Database
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