Re: Converting from WE8MSWIN1252 to WE8ISO8859P1

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Sat, 17 Apr 2004 19:40:02 GMT
Message-ID: <mKfgc.14186$G_.12080@nwrddc02.gnilink.net>

"Adam McDonagh" <adam_at_ski2000.fsnet.co.uk> wrote in message news:408186e2$0$25243$cc9e4d1f_at_news-text.dial.pipex.com...
> Thanks for all your quick replies.
>
> I managed to get my character set back to what it should be.
>
> My problem is basically this...
> I have a Win2k Pro server running Oracle 9i from which a database is
> currently stored. I wish to transfer everything from this server onto a new
> Linux PC that I have, running 10g.
>
> The charset on Windows database is WE8MSWIN1252, and WE8ISO8859P1 on my
> Linux box.
>
> I have exported the database from the windows server to import onto my Linux
> box. This all imports fine, however all the pound signs (£) are replaced
> with hashes (#).
>
> I have tried changing the Linux box to the MSWIN charset, but this didn't
> work... What would be the correct procedure for me to be able to keep all
> the poundsigns in my database? Do I need to change the windows box to the
> ISO character set and then run an export... But if I do this, will the
> poundsigns on the windows box still be ok?
>
> Thanks for your patience
>
> Adamski
>
>

Did you set your NLS_LANG correctly?

It should have been set to something like: American_America.WE8MSWIN1252 both on exp and imp.

Anurag Received on Sat Apr 17 2004 - 14:40:02 CDT