[Lazarus] Posting image into Sqlite with CreateBlobStream not working

[Luiz Americo Pereira Camara]

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