Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h462khB12380 for ; Mon, 5 May 2003 21:46:43 -0500 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h462khA12375 for ; Mon, 5 May 2003 21:46:43 -0500 Received: from fatcity.com (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id RAA05547; Mon, 5 May 2003 17:21:51 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 005906B1; Mon, 05 May 2003 16:31:36 -0800 Message-ID: Date: Mon, 05 May 2003 16:31:36 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Orr, Steve" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Orr, Steve" Subject: RE: Of CLOB's, multi-byte characters and NCLOB's... Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Here's a copy/paste from the Oracle docs on CLOB's and NCLOBS. ---------------------------------------------------------------- CLOB Datatype The CLOB datatype stores single-byte character data. Both fixed-width and variable-width character sets are supported, and both use the CHAR database character set. CLOBs can store up to 4 gigabytes of character data. ---------------------------------------------------------------- NCLOB Datatype The NCLOB datatype stores multibyte national character set character (NCHAR) data. Both fixed-width and variable-width character sets are supported. NCLOBs can store up to 4 gigabytes of character text data. ---------------------------------------------------------------- The docs make it sound like CLOB's only store single-byte data and not multi-byte data. On a UTF8 database we were able to store Japanese kanji in a column of type CLOB. In a browser the kanji displays as kanji according to our session NLS settings. (Pardon my apparent xenophobia but they just look like chicken scratchings to me ;-) -----Original Message----- Sent: Monday, May 05, 2003 3:52 PM To: Multiple recipients of list ORACLE-L Steve I don't understand this at all, but I happened to be reading on this, and I think the difference is between the "Database Character Set" and the "National Character Set". CLOB works with the Database Character Set and NCLOB works with the National Character Set. If at database creation time you don't specify a National Character Set, it defaults to your Database Character Set. Someone earlier posted the following query on this list: select name, substr(value$,1,20) from sys.props$ This displays all your NLS stuff for your database. Okay, we have now exceeded what I know about this subject, and hopefully someone on this list that actually understands the multi-byte character sets will provide a further explanation. Dennis Williams DBA, 60%OCP, 100% DBA Lifetouch, Inc. dwilliams@lifetouch.com -----Original Message----- Sent: Monday, May 05, 2003 2:22 PM To: Multiple recipients of list ORACLE-L We have several columns of datatype CLOB and one of our developers says we can store multi-byte characters in Oracle CLOB columns because multi-byte characters are just a few single-byte characters strung together. Sure enough, using OCI our app displays multi-byte Kanji characters just fine. Interesting! So that being the case, what's the difference between CLOB's and NCLOB's? If CLOB's work just fine for storing multi-byte characters then why even bother with NCLOB's? Even though our app has been working just fine by storing multi-byte characters in CLOB's, are there any potential gotchas? Still trying to get back into productive work after IOUG... Steve Orr Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: sorr@rightnow.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: DWILLIAMS@LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: sorr@rightnow.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).