Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: change database character set

Re: change database character set

From: joel garry <joel-garry_at_home.com>
Date: 12 Dec 2006 14:21:25 -0800
Message-ID: <1165962085.747051.212130@j44g2000cwa.googlegroups.com>

aman.oracle.dba wrote:
> sybrandb wrote:
> > On Dec 12, 11:13 am, "peter" <hhh.datab..._at_gmail.com> wrote:
> > > Hi all,
> > >
> > > How to change database character set US7ASCII to UTF8 in oracle 9.2 on
> > > Sun Solaris.
> > > Please inform.
> > >
> > > Thanks
> >
> > Please read the SQL reference manual, 'ALTER DATABASE' statement.
> > Please avoid doc questions.
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> It is there but according to that CLOB will create problem, that's why
> I am discussing here.
> Please inform how to solve the CLOB problem.

You need to export the CLOB before changing the character set, and import it after.

See "Use Scanner Utility before Altering the Database Character Set" metalink Note:123670.1
. See AL32UTF8 / UTF8 (unicode) Database Character Set Implications metalink Note:119119.1 .

If you've done something like insert 8 bit data into your 7 bit database, you will have to do more than:

  1. Export the current entire database (with NLS_LANG set to <your old database character set>)
  2. Create a new database in the AL32UTF8 character set
  3. Import all data into the new database (with NLS_LANG set to <your old database character set>)

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20061211/news_1n11sales.html
Received on Tue Dec 12 2006 - 16:21:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US