Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: change character set
Such a parameter does exist, but please be absolutely certain that you
understand exactly what this does before you attempt to use it. I would
strongly advise that you not do this without approval from Oracle Support,
and that you are 100% confident in your backup before you start, since it
has the potential to do very bad things to your data. It goes without saying
that this shouldn't be done on a production system until you are confident
that it works in development and QA.
Assuming the above disclaimer hasn't dissuaded you, the command is
ALTER DATABASE CHARACTER SET INTERNAL_USE <<new character set>>
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Patrick Van der Sande
Sent: Tuesday, July 13, 2004 2:46 PM
To: oracle-l_at_freelists.org
Subject: change character set
Content-Type: Text/Plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable Dear,=0D =0D I am looking for a
hidden or undocumented parameter that is used to eliminate=0D the super set
check when a "alter dabase character set UTF8" is issued.=0D Since I am
running a database in WE8ISO859P1 I can not switch the charact= er set=0D
with the command above.=0D I know from my days at Oracle that such a
parameter exists.=0D Can somebody tell me what the parameter is ??=0D I need
it quite urgently.=0D =0D I also contacted Oracle Support but if somebody
can help me in a quicker = way =2E=0D =0D Rgds,=0D =0D Patrick Van der
Sande=0D Managing Director =0D ANDES Consulting BVBA=0D email :
patrick.van.der.sande_at_skynet.be=0D
website : http://www.andes-consulting.be
![]() |
![]() |