Re: change db character set

From: Jérôme Texier <jtexier_at_ystel.fr>
Date: Thu, 8 Apr 1999 09:45:48 +0200
Message-ID: <7ehmru$nit$1@jaydee.iway.fr>

Wai <reebok-wai_at_bigfoot.com> a écrit dans le message : 370C5692.C13C6ED2_at_bigfoot.com...
> I have create a database and have lot of data in it.
>
> Can I change the character set of the db?
> If yes, how can I do that? Is there any tool to help me?
>
> I am running oracle server 8.0.4 with win NT server 4 sp3
>

Yes you can but be careful, if you change it, you will lost any "accentuation".

Select * from sys.props$
where name = 'NLS_CHARACTERSET';

    => give you the current CHARACTERSET

and :
Update sys.props$
set value$='<NEW CHARACTERSET>'
where name='NLS_CHARACTERSET';

    => modify the characterset

It should work if my memory is good.
Be careful : you must type a good characterset !!!

DON'T FORGET TO SAVE YOUR DATABASE BEFORE. IT'S VERY DANGEROUS AND NOT SUPPORTED !!!

---

Jérôme
jt_at_ystel.fr

---

Received on Thu Apr 08 1999 - 02:45:48 CDT