Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: transferring Kanji data from Excel 2000 to Oracle8.1.6.3.0

Re: transferring Kanji data from Excel 2000 to Oracle8.1.6.3.0

From: Jim Gregory <Jim.Gregory_at_ncr.com>
Date: Thu, 8 Mar 2001 09:30:16 -0500
Message-ID: <3aa7978a@rpc1284.daytonoh.ncr.com>

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...

> 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!
>
Received on Thu Mar 08 2001 - 08:30:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US