Re: setting character set for imp

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: <janine@xxxxxxxxxx>, "'oracle-l (E-mail)'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 20 Jul 2005 00:13:49 +0200

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



--
//www.freelists.org/webpage/oracle-l

Other related posts: