On 12/7/07, Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > On Fri, Dec 07, 2007 at 05:49:56PM -0500, Igor Tandetnik wrote: > > > >So I would to ask: are there any benefits from using VARCHAR() and > > >not TEXT? > > > > There is no difference whatsoever to SQLite. It maintains the types for > > compatibility with other DMBS only > > Just from curiosity: perhaps could you tell, does it make any differences > (other than just coercing a limit) in case of other database systems (like > f.e. PostgreSQL, or other known to you)? > > If so - is it significant difference (in data access speed, or any other...)? > --
I believe it used to... fixed width (CHAR) was quicker than VARCHAR while the latter was more space efficient, obviously. One of my Oracle-ish friends was telling me that now it really doesn't matter as they are all very fast, and he just makes everything VARCHAR. Some db, perhaps under some installation conditions, will fail the operation if you try to insert a bigger string in a CHAR column. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
