Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:17330 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 95065 invoked by uid 1010); 19 Jul 2005 21:02:20 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 95050 invoked from network); 19 Jul 2005 21:02:20 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 19 Jul 2005 21:02:20 -0000 X-Host-Fingerprint: 80.74.128.22 cassius.sui-inter.net Linux 2.4/2.6 Received: from ([80.74.128.22:58273] helo=cassius.sui-inter.net) by pb1.pair.com (ecelerity 2.0 beta r(6227M)) with SMTP id 7F/B8-61486-B5A6DD24 for ; Tue, 19 Jul 2005 17:02:20 -0400 Received: (qmail 23724 invoked from network); 19 Jul 2005 23:02:17 +0200 Received: from 84-73-10-224.dclient.hispeed.ch (HELO ?192.168.32.50?) (84.73.10.224) by cassius.sui-inter.net with (RC4-SHA encrypted) SMTP; 19 Jul 2005 23:02:17 +0200 Mime-Version: 1.0 (Apple Message framework v733) In-Reply-To: <4e89b426050719132323151018@mail.gmail.com> References: <4e89b426050719132323151018@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed Message-ID: Content-Transfer-Encoding: 7bit Date: Tue, 19 Jul 2005 23:02:16 +0200 To: internals@lists.php.net X-Mailer: Apple Mail (2.733) Subject: Re: [PHP-DEV] SQlite row size From: lists@ahlenstorf.ch (Andreas Ahlenstorf) Am 19.07.2005 um 22:23 schrieb Wez Furlong: > Just because it is the library default; the intention is to make php > generate sqlite files compatible with other applications that use > sqlite. Ah, that makes sense :) > 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. I'll think about it - does the row size limit still exist in SQLite 3? Andreas