-----Original Message----- From: P Kishor [mailto:[EMAIL PROTECTED] Sent: Friday, December 07, 2007 5:50 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Any advantages of "varchar()" over "text"?
I may be wrong, but my understanding is that other than INTEGER PRIMARY KEY, SQLite doesn't give a rat's batuti about what you define a column as... for example, ... it does matter what datatype you use, just SQLite is very forgiving. But read the section on "column affinity" in the datatypes page for the importance of selecting the right types and aliases for the pre-defined types. http://sqlite.org/datatype3.html HTH, Sam ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------