Re: [sqlite] TEXT storage

2010-04-17 Thread D. Richard Hipp
On Apr 17, 2010, at 2:57 PM, slowpoison wrote: > > 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

Re: [sqlite] TEXT storage

2010-04-17 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/17/2010 11:57 AM, slowpoison wrote: > I was unable to find a reference to how TEXT data types are stored in > the db files. 2.3.1 and 2.3.2 answer that: http://www.sqlite.org/fileformat.html#varint_format > I want to know whether a TEXT

[sqlite] TEXT storage

2010-04-17 Thread slowpoison
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