Is there a reason why you want to absolutely specify the maximum length for your text column? SQLite handles variable length text pretty well.
If you want to create a column that needs to be filled in for each record, just use the "NOT NULL" keyword. See : http://www.sqlite.org/lang.html and http://www.sqlite.org/lang_createtable.html CREATE TABLE monthy ( pyhton TEXT NOT NULL, -- Column constraint holy_grail TEXT CHECK(length(holy_grail) <= 20) NOT NULL ); ganbatte kudassai! Samuel On 2007-12-21 10:23, arbalest06 wrote: > good day! > > 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?.. > > 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?.. > > thanx and God bless! ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
