On 12/7/07, Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > We can define in, using SQLite, both "fixed max. width" VARCHAR() fields (I > know, in practice it can be crossed over), as well as "no limit" TEXT fields. > > So I would to ask: are there any benefits from using VARCHAR() and not TEXT? > For example faster(?) data access - or just anything, that makes establishing > such limit on the field length reasonable?
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, CREATE TABLE foo (a ELEPHANT, b ZEBRA(32)) should be a perfectly valid statement. It does provide INTEGER, REAL, DATE, TEXT, and BLOB as five types, but it is a free for all in their. You might want to define columns more specifically with a view to making your schema more portable. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
