Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: setting character set for imp
> 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-lReceived on Tue Jul 19 2005 - 17:16:48 CDT
![]() |
![]() |