SQLite saves data as null terminated strings. So it's only capable to
store CLOBS. In cvs there seems to be two functions to escape null
characters but they are not available in the sqlite.dll version 13.
It appears that all development effort is put into a complete new
version, so I'm affraid these functions will not be available in a
short notice. You can use escape routines of your own but if other
app's will need the same database you might face compatibility
problems. It's been an isue to us rather a while now.
Albert Drent
aducom software
> Dear sirs,
>
> I am trying to develop techniques to save BLOBs in Sqlite. What is
the best
> way to save jpg(S), bmp(s), etc?
>
> Would it be best to use GetBitmapBits ("gdi32" library) and then save
to
> Sqlite as a byte array or is there a more efficient method?
>
> I am new to Sqlite but it seems to be an amazing tool!
>
> I look forward to any help and I thank you in advance for your input.
>
> Sincerely,
> Ed Porter
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
--
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
