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?
 
schwertnerConnect With a Mentor Commented:
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
 
sujith80Commented:
What is the NLS_LANGUAGE setting?
0
 
dalebettsConnect With a Mentor Commented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Jinesh KamdarConnect With a Mentor Commented:
Try this : ALTER SESSION SET NLS_LANGUAGE = 'CHINESE';
0
 
sujith80Connect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.