Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!post02.iad01!post01.iad01!not-for-mail Date: Tue, 12 Dec 2006 09:15:11 -0800 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: change database character set References: <1165918434.288500.109650@n67g2000cwd.googlegroups.com> <1165920629.903390.37220@l12g2000cwl.googlegroups.com> <1165925634.832039.31130@79g2000cws.googlegroups.com> In-Reply-To: <1165925634.832039.31130@79g2000cws.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1165943710.796214@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 30 X-Complaints-To: abuse@csolutions.net Xref: usenetserver.com comp.databases.oracle.server:419023 X-Received-Date: Tue, 12 Dec 2006 12:15:11 EST (text.usenetserver.com) aman.oracle.dba wrote: > sybrandb wrote: >> On Dec 12, 11:13 am, "peter" 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. What CLOB problem? If you read something that is causing concern post the link and the relevant paragraph(s). If you expect others to redo your research you'll likely not receive an answer. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org