Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h45NiES06496 for ; Mon, 5 May 2003 18:44:14 -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 h45NiDA06491 for ; Mon, 5 May 2003 18:44:14 -0500 Received: from fatcity.com (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id OAA94252; Mon, 5 May 2003 14:19:23 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 005904AC; Mon, 05 May 2003 13:52:15 -0800 Message-ID: Date: Mon, 05 May 2003 13:52:15 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: DENNIS WILLIAMS Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: DENNIS WILLIAMS 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: 7bit 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).