Storing a great many fields in a database

[Dr. Hawkins]

On Mon, Jul 16, 2012 at 11:26 AM, Bob Sneidar <bobs at twft.com> 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
HawkinsLawFirm at gmail.com
3025 S. Maryland Parkway
Suite A
Las Vegas, NV  89109