On Mon, Jul 16, 2012 at 11:26 AM, Bob Sneidar <[email protected]> wrote: > I think then that for SQLITE TEXT is actually synonymous with VARCHAR. It was > my understanding that VARCHAR allowed for an economical use of space, but was > slower >to index. The engine would use just enough space, up to the limit set, to >store the values, >truncating the excess. I seem to remember that one of the string types >(perhaps CHAR) >always stored trailing spaces up to the limit, and this produced faster >indexes.
according to postrgesql's docs, it costs the string length plus one byte for varchar of less than 126 characters, and the stringlength + 4 bytes for anything longer. -- The Hawkins Law Firm Richard E. Hawkins, Esq. (702) 508-8462 [email protected] 3025 S. Maryland Parkway Suite A Las Vegas, NV 89109 _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
