[Lazarus] Posting image into Sqlite with CreateBlobStream not working

Luiz Americo Pereira Camara luizmed at oi.com.br
Thu Feb 5 17:19:20 CET 2009


Paul van Helden escreveu:
> Hi,
>
> When I put image data into a BLOB field with 
> TSqlite3Dataset.CreateBlobStream and query BlobStream.Size the returned 
> size is much smaller than the data copied into the stream.
>
> So far I have traced it to line 366 in 
> fpc\2.2.3\source\packages\fcl-db\src\sqlite\customsqliteds.pas:
>
> FRowSize:=StrLen(NewRow);
>
> NewRow, having just received some image data, contains #0's, so StrLen 
> returns undesired result. Line 326 must also be wrong.
>
> How to fix?
>   

Binary blob fields are not supported by sqlite3dataset currently. You 
can try http://source.online.free.fr/ or sqldb.


Luiz



More information about the Lazarus mailing list