Re: Changing Oracle 7 Character Set

Hi,
with US7ASCII, which is a 7-bit character set, you have practically no other choice than to recreate the database. The use of nls_lang, etc. does not help here. It would help if the database were created in some other 8-bit character set which "knows" the characters interesting for your application vendor.

Regards,
Pavel

Michael VanTyne <mvt_at_xmission.com> schrieb im Beitrag <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 Thu Mar 19 1998 - 00:00:00 CST