Oracle Database Discussions

Hi All,

I am having oracle 10g Enterprise Edition on Linux machine.
My requirement is to support the English character set and also the other languages (Japanese, Chinese e.t.c) character set.

Currently my Character set settings are listed as below.

SELECT * from NLS_DATABASE_PARAMETERS

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16

SELECT * FROM NLS_INSTANCE_PARAMETERS;

NLS_LANGUAGE AMERICAN

SELECT * FROM NLS_SESSION_PARAMETERS;

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA

After going through the Oracle forums, I tried the following…

Updated NLS_LANGUAGE and NLS_CHARACTERSET values system column.value in sys.props$ table.

My updated nls parameters are

NLS_LANGUAGE AMERICAN_AMERICA.UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_TERRITORY AMERICA
NLS_CHARACTERSET AL32UTF8

After updating the character set as above, Now when I insert the Japanese characters like (森林浴サラウンド ブルーレイ・エディション) into oracle database tables, I found incorrect characters being inserted as “î—tµé¦óÉ Öëüì¤û¨Ç£•çó”.

What should be the nls parameters to support multiple languages (Japanese, Chinese, English etc…)? Suggest me asap, How can I achieve this ? Please provide me detailed steps..



Thanks in advance
Nuthan Prasad.K