db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mag Gam <magaw...@gmail.com>
Subject Re: text datatype
Date Sun, 25 Sep 2005 18:23:30 GMT
Wolfang:

Hmm! Very interesting. What about if I use something like Lucene to index my
data?

I am trying to build a simple database to put my "notes" and do a quick
search on them when I need some info....


ANy ideas now???


On 9/25/05, wolfgang127us@yahoo.co.jp <wolfgang127us@yahoo.co.jp> wrote:
>
> 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
> supported.
> 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.
> --------------------------------------------------------
>
> Regards,
> Wolfgang.
>
>
>
> __________________________________
> For All Sports Fans!
> http://pr.mail.yahoo.co.jp/yells/
>
>
Mime
View raw message