http://www.sqlite.org/c3ref/blob_open.html http://www.sqlite.org/c3ref/blob_bytes.html
Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________________ From: [email protected] [[email protected]] on behalf of Yves Goergen [[email protected]] Sent: Sunday, February 06, 2011 4:40 AM To: General Discussion of SQLite Database Subject: EXT :[sqlite] LENGTH on a BLOB field stops at NUL byte Hi, I'm storing small files in a BLOB field in the database. I'd like to determine the size of such a file with an SQL query without fetching the data. I tried using the LENGTH() function on that field but it stops counting at the first NUL byte. A 3.2 KiB GIF image is reported to be only 7 bytes long, that's just the file header length. Is this a bug or should I use another function on binary data? The SQLite version is 3.6.20 from PHP 5.3.1 on Windows XP. -- Yves Goergen "LonelyPixel" <[email protected]> Visit my web laboratory at http://beta.unclassified.de _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
