Landguage setting in oracle

I am inserting some data into an oracle table no constraints, just a staging table, and the data is inserted with an informatica mapping, and all the correct languages settings are used on the informatica side we use MS simplified Chinese, but when I extract the data from the staging table the characters come out different, an example the data before it is inserted is like «G 47M(„), but when it is extracted looks like ¤÷ 47M(¤÷)

I know that I am using an ETL tool to insert and extract the data, but I have set all the correct setting to use the language in the tool and have checked the setting in oracle (SELECT * From v$NLS_PARAMETERS)  and they are as follows:

PARAMETER      VALUE
NLS_LANGUAGE      ENGLISH
NLS_TERRITORY      UNITED KINGDOM
NLS_CURRENCY      £
NLS_ISO_CURRENCY      UNITED KINGDOM
NLS_NUMERIC_CHARACTERS      .,
NLS_CALENDAR      GREGORIAN
NLS_DATE_FORMAT      DD-MON-RR
NLS_DATE_LANGUAGE      ENGLISH
NLS_CHARACTERSET      AL32UTF8
NLS_SORT      BINARY
NLS_TIME_FORMAT      HH24.MI.SSXFF
NLS_TIMESTAMP_FORMAT      DD-MON-RR HH24.MI.SSXFF
NLS_TIME_TZ_FORMAT      HH24.MI.SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT      DD-MON-RR HH24.MI.SSXFF TZR
NLS_DUAL_CURRENCY      ¬
NLS_NCHAR_CHARACTERSET      AL16UTF16
NLS_COMP      BINARY
NLS_LENGTH_SEMANTICS      BYTE
NLS_NCHAR_CONV_EXCP      FALSE

I need to use something like MS Windows Simplified Chinese, but I dont know what this would be in oracle?
mmatharuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SujithData ArchitectCommented:
What is the NLS_LANGUAGE setting?
0
dalebettsCommented:
It could also be th fact that oracle net is interperating the languages in a weird way, if the oracle character set is slightly different totat of the operating system then oracle net is there to sort these out between the two.

Regards
0
Jinesh KamdarCommented:
Try this : ALTER SESSION SET NLS_LANGUAGE = 'CHINESE';
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

SujithData ArchitectCommented:
Sorry,
read my previous post as NLS_LANG.
What is the NLS_LANG setting used from connecting thru informatica?
0
mmatharuAuthor Commented:
also the files that we recieve are in Unicode and we then have to change them to UTF-8, but the NLS_Lang in informatica is MS Simplified Chinese.
0
schwertnerCommented:
Your Database setting is very good (NLS_CHARACTERSET      AL32UTF8).
You have to set the NLS_LANG=.UTF8 on the server side.
This is environment variable.

If the data comes from other databases the tool that extracts (Export, ETL Tool) should be also
parametrized to work as UTF8 tool. If it uses Oracle Client behind you should set
either NLS_LANG=.UTF8 or something more specific in the environment.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.