Japanese charecters looks like junk when loaded to oracle 9i

sun786 · Post by **sun786** » Mon Mar 06, 2006 4:39 am

There is some japanese data to be loaded to oracle 9i database ( UTF-8 ) .

Data looks like junk after its loaded through datastage to oracle tables.

what are the settings that I need to take care to load japanese chars to oralce.

Note : My source is SAP BW....using extract pack to pull data...
Please advise.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 06, 2006 7:26 am

There are at least 14 different ways that Japanese characters are encoded, including Shift-JIS. You need to find out how the data are encoded, and set the DataStage NLS map to that. You may also need to set environment variables such as NLS_LANG.

palaniappan · Post by **palaniappan** » Mon Mar 06, 2006 7:38 am

What you see is not neccessarily what is stored in the DB. It depends on the settings of your PC for ex. So use the dump function and get the hex values of the data stored and check if they are what you intended to store.

Select dump(<column_name>,16) from <table_name>;

Thanks, Pal.