Re: SQlite row size

Just because it is the library default; the intention is to make php generate sqlite files compatible with other applications that use sqlite. IIRC, you can happily exceed this "limit", it'll just be slower to access such a row. To be honest, support for blob style data in sqlite 2 and below is pretty crappy; if you're serious about it, I'd suggest upgrading to PHP 5.1 and using PDO SQLITE instead. SQLite 3 (which it uses) actually has a concept of binary data. --Wez. On 7/19/05, Andreas Ahlenstorf <lists@ahlenstorf.ch> wrote: > Hi, > > I'm playing around with SQlite in PHP 5 and as far as I can see, the > row size is limited to 1 MB, even it's possible to set it up to 16 > MB. What's the reason for it? I know I can change it for myself when > I recompile the extension, but that's quiet hard on Windows without a > compiler and without the required knowledge... > > Andreas > > -- > PHP Internals - PHP Runtime Development Mailing List > To unsubscribe, visit: http://www.php.net/unsub.php > >