Re: change db character set

From: <kswonghk_at_my-dejanews.com>
Date: Sat, 24 Apr 1999 13:50:07 GMT
Message-ID: <7fsi6e$21g$1@nnrp1.dejanews.com>

In article <7ehmru$nit$1_at_jaydee.iway.fr>, "Jérôme Texier" <jtexier_at_ystel.fr> wrote:
> 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 only works in v7. You have to use undocumented command in v8. But, the savest way is to recreate db, and take care NLS_LANG when doing imp/exp.

Regards,
Steven Wong

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Apr 24 1999 - 08:50:07 CDT