Loading japanese and chinese data

[ckiltz]

Hello,

we want to import/load japanese and chinese data into our oracle 10g db with NLS_CHARACTERSET=AL32UTF8. Until the point of time there are only german data inside the db. The data come to us from SAP as text file for loading with SQL*Loader. Are there special settings to be done on SQL*Loader-Site?

What settings (oracle parameter, environment parameter) have to be changed on the server site and on client site to import the data accurate?

Are there any White Papers to go step by step?

It seems to be very complex topic to me!

Thank you for help!

Christian

[ckiltz]

Good morning,

now I loaded the data into the database with the following parameter in SQL*Loader-Parameter file:

CHARACTERSET JA16SJIS

and it seems to work (log file output: "Character Set JA16SJIS specified for all input.") but ...

the select statement to control the data does not work. I got signs like this

"èöÄ«ë´Äð╠¿Ï»╠▀¢ü@┤┌©─█ã©¢ü@╝̼╩▀¦"

If I display the data in Firefox with Charakter Encoding = "Japanese (Shift_JIS) I got the following output:

ﾅ窶敘ｽﾂｮ窶ｰﾃｯﾅｽﾃ静個ｨﾃ伉ｯﾃ古淞ｽﾂ　ﾂｴﾃ堋ｸﾃ・崚・ｸﾂｽﾂ　ﾂｼﾃ楪ｬﾃ甘淌・ﾅｽD窶土ﾆ棚ﾆ稚ﾆ達ﾆ湛 ﾅｽD窶土ﾅｽs

It looks better for me!

The NLS_LANG in the registry is: GERMAN_GERMANY.AL32UTF8 and I did not set NLS_LANG in the environment. The tool for the select statement is sqlplus (command line) and sql scratchpad does not work as well!

useful link: http://www.oracle.com/technology/tec...#_Toc110410566

Any sugestions?

Thank you in advance!

Christian