arbalest06 <[EMAIL PROTECTED]> wrote:
i want to create a database with a table that has a column which is a TEXT..i want to specify the maximum length of the text..but i cant do TEXT(20)( ie., 20 characters max )..how can i do this?..
create table t (a text check(length(a) <= 20));
also i would like to specify that this column should be a required field..so if the column was not given a value during insert, it would return an sqlite error code..how can i implement this?..
create table t (a text check(length(a) <= 20) not null); Igor Tandetnik ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
