Korean data load from Excel sheet to Oracle table

**Harshal** · Jun 27 '08, 05:06 PM

Hi all,

we are trying to load Korean data from a Excel Sheet in to Oracle
Database (8.1.7.3 with NLS_LANG=Americ an_America.UTF8 )

We successfully transferred the Unicode file to our Unix server... now
on server side, what should we set to NLS_LANG so that when we perform
dataload via sqlloader, it will be in right format and when u spool
the select on the recently loaded data it will be Korean data.. not
junk Chars like Boxes and ???....

We tried setting NLS_LANG to Korean_Korea.UT F8 as well as
American_Americ a.KO16KSC5601 but everything, sql loader will return NO
errors.. and when u do select on the table and try to view data in
IE.. it's all Junk Chars..

What we should do so that we can see Korean Characters into Database
tables?

Thanks and waiting for ur valuable Input.

Thanks.

Harshal