Hi All,

What is the difference between Character Set and National Character Set. I have a small database and i want to store Korean,Japanese,Swedish characters and display the same. How do i achieve this. Currently this is setting that i have

SQL> SELECT name,value$ FROM sys.props$;

NAME VALUE$
------------------------- -----------------------------------
DICT.BASE 2
DBTIMEZONE 0:00
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CharacterS .,
NLS_CharacterSet WE8ISO8859P1
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 TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_NCHAR_CharacterSet WE8ISO8859P1
NLS_RDBMS_VERSION 8.1.7.2.0
GLOBAL_DB_NAME SDT
EXPORT_VIEWS_VERSION 8

I read it somewhere that i have use UTF 8 character set in order to store other language characters. If this is the case, what should be the National Character set be set to.

Appreciate all your help.

Regards

Raghavan