Answers in line.
> -----Original Message-----
> From: arbalest06 [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 21, 2007 9:23 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] database column attributes
>
>
>
> 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?..
>
MyText VARCHAR(20) (SQLite will not enforce the column size limit.
That's the programmer's job:-)
> 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?..
>
MyText VARCHAR(20) Not Null (SQLite will enforce this one.)
> thanx and God bless!
> --
> View this message in context:
> http://www.nabble.com/database-column-attributes-tp14457206p14
457206.html
Sent from the SQLite mailing list archive at Nabble.com.
------------------------------------------------------------------------
-----
To unsubscribe, send email to [EMAIL PROTECTED]
------------------------------------------------------------------------
-----
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
