[sqlite] Re: database column attributes

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 wou

[sqlite] Re: database column attributes

arbalest06 <[EMAIL PROTECTED]> wrote: i got it working already..thank you so much!..would this check(length(a) <= 3 also work if the datatype is integer? If you want to limit an integer, just write check(a <= maxValue) Igor Tandetnik ---

Re: [sqlite] Re: database column attributes

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