Re: Changing Oracle 7 Character Set

Hi Michael,

I tried this in Oracle 7.1, 7.2. I don't know about 7.3.

1. Make full cold backup of your database.
2. Connect internal.
3. Startup database.
4. Check, that WE8ISO8859P1 is supported character set by your Oracle version.
5. Execute this very carefully:

update sys.props$
set value$='WE8ISO8859P1'
where name='NLS_CHARACTERSET';
commit;

6) Shutdown.
7) Startup.

                                  Andrew Protasov

Michael VanTyne wrote in message <3509AED4.87FD58B2_at_xmission.com>...
>I am running 7.3.2.2 server on Solaris 2.6. My production database was
>created with the US7ASCII (default) character set. I have come to find
>out from my application vendor that their product requires the
>WE8ISO8859P1 character set (...now they tell me).
>
>As I understand it, I cannot go back now and change the character set
>for that database without re-creating it. It sounds like the other
>option would be to use Solaris user envirmonment variables (nls_lang,
>ora_nls, etc) to control that.
>
>Does anyone have any experience (good or bad) in swapping out the
>database character set? My users will appreciate it when the symbol for
>micro - CHR(181) - stops showing up as a "5".
>
>Any input would be appreciated.
>
>Michael VT
>
Received on Fri Mar 20 1998 - 00:00:00 CST