Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!79g2000cws.googlegroups.com!not-for-mail
From: "aman.oracle.dba" <aman.oracle.dba@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: change database character set
Date: 12 Dec 2006 04:13:54 -0800
Organization: http://groups.google.com
Lines: 21
Message-ID: <1165925634.832039.31130@79g2000cws.googlegroups.com>
References: <1165918434.288500.109650@n67g2000cwd.googlegroups.com>
   <1165920629.903390.37220@l12g2000cwl.googlegroups.com>
NNTP-Posting-Host: 192.127.94.7
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1165925640 16084 127.0.0.1 (12 Dec 2006 12:14:00 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 12:14:00 +0000 (UTC)
In-Reply-To: <1165920629.903390.37220@l12g2000cwl.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 79g2000cws.googlegroups.com; posting-host=192.127.94.7;
   posting-account=yp-b7w0AAAAeseIlzSB0lLDs-NuzgUnN
Xref: usenetserver.com comp.databases.oracle.server:418984
X-Received-Date: Tue, 12 Dec 2006 07:14:01 EST (text.usenetserver.com)


sybrandb wrote:
> On Dec 12, 11:13 am, "peter" <hhh.datab...@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.