Re: database character set

From: Marc Billiet <first.last_at_com.hydro.switch.this>
Date: Tue, 27 Mar 2001 05:41:36 GMT
Message-ID: <20010327.5413678@slu40xxx.hae.hydro.com>

Oracle 8.1.7 has the 'ALTER DATABASE CHARACTER SET ' statement, which

allows to change the character set. Because you are switching from WE8ISO8859P1 to EE8ISO8859P2, in order to convert your data, you should

however first export your data, change the character set of your database, empty the database and import the data again. I don't think

that the 'alter database character set' will convert all your text to th e
new character set encoding scheme without export/import.

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2001-03-26, 23:21:59, schreef "Matjaz Habic" <matjaz.habic_at_ks-con.si>

over het thema database character set:

> Hello
> just need confirmation.

> I have database (8.1.7 on win2000 ) in WE8ISO8859P1 but now I want
> EE8ISO8859P2 character set.
> I have read about this topic on metalink and I have found solution onl
y
for
> case where destination character set is superset of source character s
et.
> (solution with ALTER DATABASE CHARACTER SET)

> The only way to do this is to recreate database (true or false ?)

> thak You

> Matjaz
Received on Mon Mar 26 2001 - 23:41:36 CST