db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lance J. Andersen" <Lance.Ander...@Sun.COM>
Subject Re: text datatype
Date Sun, 25 Sep 2005 11:04:47 GMT
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