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:
NLS_TERRITORY UNITED KINGDOM
NLS_ISO_CURRENCY UNITED KINGDOM
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
I need to use something like MS Windows Simplified Chinese, but I dont know what this would be in oracle?