Storing a great many fields in a database

[Bob Sneidar]

I did not mean the LC engine I meant the SQL engine (if it is acceptable to refer to it in that way). 

Bob


On Jul 16, 2012, at 12:45 PM, Peter Haworth wrote:

> The engine (if you mean the Livecode engine) has nothing to do with it, or
> at least it shouldn't.  How VARCHAR works varies between SQL
> implementations.  For sqlite, there is no difference between TEXT and
> VARCHAR - they end up using only as much storage as needed.  Pretty much
> the same for mySQL, but I believe other implementations don;t work that way.
> Pete