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 14:55:23 GMT
Lance:

Thanks! Thats exactly what I am looking for. Now I need to index this CLOB
for searching. But thats another story.

Thanks!


On 9/25/05, Lance J. Andersen <Lance.Andersen@sun.com> wrote:
>
> I would use the CLOB datatype.
>
> -lance
>
> Mag Gam wrote:
>
> > Is there a text datatype for Derby? Currently I am using long varchar,
> > but I may have very LARGE data in my description field.
> >
> > CREATE TABLE INFO
> > (info_id int generated by default as identity (START with 1, INCREMENT
> > BY 1),
> > title long varchar,
> > description long varchar);
> >
> > INSERT INTO info (title,description)
> > VALUES ('Starting Derby','Here is the description to start up derby');
> >
> >
> > TIA!
> >
>

Mime
View raw message