Hi, I was unable to find a reference to how TEXT data types are stored in the db files. The file format comment in btreeInt.h is too complex (or may be the wrong place) for me to deduce what I'm looking for.
I want to know whether a TEXT field, when stored, will always take the exact amount of space allocated for it in the schema definition. So, when I say TEXT(1024), is the field guaranteed to take 1024 bytes on disk per record or is there a non-trivial storage scheme at work similar to VARCHAR types, which tries to optimize space usage. thanks! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
