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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: setting character set for imp

Re: setting character set for imp

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 20 Jul 2005 00:13:49 +0200
Message-ID: <01d301c58caf$2571d630$d800a8c0@IBME1D11967173>


> True enough. imp doesn't seem to have a way to set charset, so I set an
> environment variable called NLS_LANG to .US7ASCII and tried again - same
> result.

Really?

As far as I know the data have to be converted properly to WE8ISO8859P1 ....

export NLS_LANG=AMERICAN_AMERICA.US7ASCII imp ....

Try with some select after the import (this time with NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 because the data will be already converted):

HTH
Dimitre Radoulov

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 19 2005 - 17:16:48 CDT

Original text of this message

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