[jifty-devel] question about binary encoding
bart at bunting.net.au
Thu Mar 16 20:20:44 EST 2006
Sorry, I'm using a screenreader and didn't listen to that line in it's
entirety, should pay more attention.
Anyway the odd thing is that it returns 9 for the length. Which seems
strange given that the output is 1100k or so. and the input is about 650k.
The 9 appears to be correct in that when i do the select 9 chars are
printed, some of them are obviously binary things the screen reader
describes the first for example as "a tilda inverted questionmark" whatever
that is :).
> -----Original Message-----
> From: jifty-devel-bounces at lists.jifty.org
> [mailto:jifty-devel-bounces at lists.jifty.org]On Behalf Of Jesse Vincent
> Sent: Friday, March 17, 2006 12:03 PM
> To: Nifty apps in a Jiffy
> Subject: Re: [jifty-devel] question about binary encoding
> On Fri, Mar 17, 2006 at 10:29:37AM +1100, Bart Bunting wrote:
> > Hi,
> > I'm not sure how to get sqlite to show me the size of the binary blob.
> sqlite> select * from pages;
> 1|Welcome to your Wifty|HomePage|2006-02-17 21:49:08|
> sqlite> select length(content) from pages;
> jifty-devel mailing list
> jifty-devel at lists.jifty.org
More information about the jifty-devel