[jifty-devel] question about binary encoding

Bart Bunting 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;
> 21
> sqlite>
> _______________________________________________
> jifty-devel mailing list
> jifty-devel at lists.jifty.org
> http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel

More information about the jifty-devel mailing list