Patch to fix problems on SQLite Blob Fields
Posted: 29.11.2010, 05:09
Hello everyone,
In order to migrate to Firebird 2.5, I decided to test Zeos 7.0.0 again
My application uses SQLite and Firebird. I noticed that a blob field in my table in SQLite was not correctly read, while the same field, from the same table, but in Firebird (with the same structure and data), was accessed correctly.
Investigating the problem, I noticed that when the field immediately prior to the Blob field is null, the contents of the Blob is despised ...
Debugging the source code, I noticed that in some Units within "dbc" directory, when the Blob contents is readed, the internal variable "LastWasNull" is not being set ... so this cause the problem ...
The patch attached contains modifications to some Units on DBC, adjusting the content of "LastWasNull" on "GetBlob"
Please consider whether the changes are correct, and if it can be integrated with SVN sources
Thanks
In order to migrate to Firebird 2.5, I decided to test Zeos 7.0.0 again
My application uses SQLite and Firebird. I noticed that a blob field in my table in SQLite was not correctly read, while the same field, from the same table, but in Firebird (with the same structure and data), was accessed correctly.
Investigating the problem, I noticed that when the field immediately prior to the Blob field is null, the contents of the Blob is despised ...
Debugging the source code, I noticed that in some Units within "dbc" directory, when the Blob contents is readed, the internal variable "LastWasNull" is not being set ... so this cause the problem ...
The patch attached contains modifications to some Units on DBC, adjusting the content of "LastWasNull" on "GetBlob"
Please consider whether the changes are correct, and if it can be integrated with SVN sources
Thanks