Re: text datatype

[Lance J. Andersen]

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!