Re: Objects in Database

--- In sqlite-F5Bj5G+ccuY@xxxxxxxxxxxxxxxx, "D. Richard Hipp" <drh@xxxx> wrote:
> richa_verma77 wrote:
> > 
> > Can I store objects in the database?
> 
> There is still a 1MB size limit on each row of data.  The data
> is also not allowed to contain '\000' characters, so you have
> to encode the data somehow if it is binary.
> -- 
> D. Richard Hipp -- drh-KGpdMs7P1Kc@xxxxxxxxxxxxxxxx -- 704.948.4565

Data containing 0 bytes can be encoded using the undocumented(?) 
functions sqlite_encode_binary() and sqlite_decode_binary(), which 
are in "encode.c". This file is in the unix source tarball, but I'm 
not sure that it's in the Windows one, and it hasn't been exported 
from the Windows DLL in the past.

Jim Lyon
(jplyon ta attglobal tod net)


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/JjlUgA/vN2EAA/xGHJAA/EbFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
sqlite-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/