db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wolfgang12...@yahoo.co.jp
Subject Re: text datatype
Date Sun, 25 Sep 2005 17:01:30 GMT
Hi Mag,

As long as the doc (http://db.apache.org/derby/docs/10.1/ref/rrefjdbc96386.html)
says true,
you cannot index the CLOB column.

---here is a snippet of the doc-------------------------
* Restrictions on BLOB, CLOB, (LOB-types): 
LOB-types cannot be compared for equality(=) and non-equality(!=, <>. 
LOB-typed values are not order-able, so <, <=, >, >= tests are not
LOB-types cannot be used in indices or as primary key columns. 
DISTINCT, GROUP BY, ORDER BY clauses are also prohibited on LOB-types. 
LOB-types cannot be involved in implicit casting as other base-types. 


 For All Sports Fans!

View raw message