[jifty-devel] question about binary encoding

Bart Bunting bart at bunting.net.au
Thu Mar 16 20:12:00 EST 2006


Jesse,

Yes, but as shown below I can only see part of the output and I'm not sure
how to tell the actual size of the object stored in the database.

Note: seems that some of the funny chars have been lost in the cut and
paste.


Bart


sqlite> select * from products;
1|test|EExif|EExif|test1
sqlite>


> -----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