i got it working already..thank you so much!..would this check(length(a) <= 3 also work if the datatype is integer?
Igor Tandetnik wrote: > > 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] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/database-column-attributes-tp14457206p14457666.html Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
