Ken <[EMAIL PROTECTED]> wrote: > > I don't think sqlite supports column level check contstraints. >
SQLite has supported CHECK constraints since version 3.0.0, released one year ago this coming Thursday. On the other hand, a CHECK constraint cannot modify data going into a table. It will only block the insertion if the data is not well-formed. If you want to trim whitespace on insert, why not just say so: INSERT INTO table VALUES(trim(?),trim(?),trim(?)); Instead of: INSERT INTO table VALUES(?,?,?); SQLite allows arbitrary expressions in the VALUES clause of an insert. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------