Zbigniew Baniewski <zb-pij/[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?
There is no difference whatsoever to SQLite. It maintains the types for
compatibility with other DMBS only: internally, there is only one string
type and it supports strings of unlimited length. The length specified
in VARCHAR() spec is ignored. For more details, see
http://sqlite.org/datatype3.html
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
