Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: transferring Kanji data from Excel 2000 to Oracle8.1.6.3.0
What character set is your database built with? What is your NLS_LANG variable set to?
-- Jim Gregory Principal Consultant for Keane, Inc. Currently assigned to NCR, Dayton, OH Opinions are my own and do not reflect those of my employer or clients "UnixDBA" <unixdba_at_aol.com> wrote in message news:20010306225742.22402.00000440_at_ng-mi1.aol.com...Received on Thu Mar 08 2001 - 08:30:16 CST
> I have Kanji data entered and viewable in a Microsoft Excel 2000
spreadsheet.
> When I Save As a tab delimited text file, and try to SQL*Load the data
into my
> Oracle database, all I see is junk characters. Somehow the Kanji
characters get
> corrupted in this transfer process.
>
> Has anyone ever done this transfer successfully? Please email responses to
> UnixDBA_at_aol.com. Cheers!
>
![]() |
![]() |