Re: ? changing to we8dec character set problems

In article <32DDA08C.6447_at_ix.netcom.com>, david flinn/jennifer opp <flopp_at_ix.netcom.com> 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 ?
>
>Any thoughts?
>
>Please respond to : dflinn_at_kpmg.com
>
>Thanks !
>
>david

Officially, the character set is one of the parameters that can only be set at

database creation. Under certain circumstances, it is possible however, to change the characterset using a sql script. There should be no problem changing from US7ASCII to WE8DEC. I used the script to change from US7ASCII to WE8ISO8859P1. The script can be found on the Oracle support notes CD or possibly by calling Oracle support. I can also mail it to you if you like. Received on Wed Jan 22 1997 - 00:00:00 CST