Blob-Support for Files > 1 MB

[Bernhard Geyer]

I download the latest CVS-Snapshot today an use the latest sqlite3.dll (Version 3.5.2) and try to save Files > 1 MB to the Database, but get a error that this would be too big (SQL Error: String or BLOB exceeded size limit)

As I unterstand this was a limitation of V2 (http://effbot.org/zone/sqlite-blob.htm):

The SQLITE database has limited support for large binary objects (BLOBS). There’s a limitation of 1 megabyte for each row of data, and the database uses NUL bytes to separate columns in the storage.

Note: This limitation has been removed in SQLITE 3.0.

Does this limitation still exists in ZEOS?

[Bernhard Geyer]

Hi,

I've changed the DLL with the Version that is provided with 6.6.1-beta and now it works. Which version is this DLL? When I look in the DLL with a Hex-Viewer I would think that this is 3.3.8.

[mdaems]

If you look at the name of the *.so library... it's 3.3.8 indeed. I don't know what changed between 3.3.8 and 3.5.2.
BTW. I hope you meant 'SVN snapshot' instead of CVS? If not your version is very old. We did fix some serious memory leaks recently, so please use a recent snapshot from http://zeosdownloads.firmos.at/downloads/snapshots/

Mark

[Bernhard Geyer]

We did fix some serious memory leaks recently, so please use a recent snapshot from http://zeosdownlads.firmos.at/downloads/snapshots/

Found correct URL:
http://zeosdownload.firmos.at/downloads/snapshots/

[aducom]

There's an error limiting blobs on sqlite within sqlite3.dll. It's been addressed and afaik it will be in the next formal release.