Re: Korean data load from Excel sheet to Oracle table

Harshal wrote:

> Hi all,
>
> we are trying to load Korean data from a Excel Sheet in to Oracle
> Database (8.1.7.3 with NLS_LANG=American_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.UTF8 as well as
> American_America.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
The same as the client you use to view back the data... It's the network layer that does transformations.

-- 
Regards, Frank van Bortel