Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Of CLOB's, multi-byte characters and NCLOB's...
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_at_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_at_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_at_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).
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_at_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). Received on Mon May 05 2003 - 16:52:15 CDT