Re: ? changing to we8dec character set problems

david flinn/jennifer opp wrote:
>
> Hi,
>
> I have a Oracle 7.2.3 server running as US7ASCII. I received
> an export file in WE8DEC. When I load it, the server "corrupts"
> the german characters to jibberish.
>
> When I change NLS_LANG in the init.ora to dutch danish, it does'nt
> matter.
>
> Can I leave the server running US7ASCII, drop the old database,
> create a new one as WE8DEC, load the data, and have things work?
>
> Do I need to reinstall the whole thing from scratch ?

When you say reinstall, do you mean reinstall ORACLE? I don't think you will have to reinstall oracle. I was forced to change character set once before and just had to drop the database and recreate using the correct character set. This is an option that is selected at databases create time.

>
> Any thoughts?
>
> Please respond to : dflinn_at_kpmg.com
>
> Thanks !
>
> david

Hope this helps,

John Hough

ps: get a backup before you start Received on Fri Jan 17 1997 - 00:00:00 CST