Re: Character set is wrong after exp/imp operation (£'s show as #'s)

"David Goodall" <davidg_at_bluewave.com> wrote in message news:2a9f8213.0112201015.693e70d8_at_posting.google.com...
> Hi,
>
> I am trying to export an Oracle database from a Linux box to a WinNT
> box (only a temporary measure ;-) by the following method:
>
> ./exp system/password full=Y file=filename.dmp
>
> imp userid=system/password_at_dbname full=y file=filename.dmp
>
> The import is into a newly created database, with the characterset
> WE8ISO8859P1.
>
> Everything works fine except that all instances of "£" are replaced
> with "#"
>
> I then tried again with a fresh database, using the WE8DEC
> characterset, but got the same result.
>
> Any help would be much appreciated.
>
> Cheers,
> David.

You need to set NLS_LANG on both sides as "<your language>_<your territory>.<your characterset>" of course the source database must have the correct characterset. If you look at exp's log output you should notice characterset conversion occurs when not setting NLS_LANG

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address