On Sun, 06 Feb 2011 09:23:59 -0500, Black, Michael (IS) <michael.bla...@ngc.com> wrote:
> C is better than everything else, isn't it???? :-) I say it’s the language you best appreciate after all the others betray you. Yet more to the point: asm, bf, or punch-cards would be faster to develop correct code in, less painful to write, more efficient, and less bug-prone than PHP. My thus snobbery is justified by experience (well—as to the PHP part), as is the wisdom of never presuming that the biggest social-network/flash-video websites know what they are doing. > He needs to add the "type" argument to bindvalue and tell it it's a blob. > > http://us2.php.net/manual/en/sqlite3stmt.bindvalue.php Actually he is using PDO, which is a different beast. PHP has at least three different ways to use SQLite (and AFAIK still comes with SQLite2 as one of them). None of them offers full access to all the useful features provided by SQLite3’s C API. Sorting out which library and version is being used in each place can be a pain, too, as briefly seen (but not really explored) in a thread I was involved in last week. Very truly, Samuel Adam ◊ <http://certifound.com/> 763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ United States Legal advice from a non-lawyer: “If you are sued, don’t do what the Supreme Court of New Jersey, its agents, and its officers did.” http://www.youtube.com/watch?v=iT2hEwBfU1g > > Michael D. Black > Senior Scientist > NG Information Systems > Advanced Analytics Directorate > > > > ________________________________________ > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] > on behalf of Samuel Adam [a...@certifound.com] > Sent: Sunday, February 06, 2011 7:49 AM > To: General Discussion of SQLite Database > Subject: EXT :Re: [sqlite] LENGTH on a BLOB field stops at NUL byte > > On Sun, 06 Feb 2011 08:22:58 -0500, Black, Michael (IS) > <michael.bla...@ngc.com> wrote: > >> http://www.sqlite.org/c3ref/blob_open.html >> http://www.sqlite.org/c3ref/blob_bytes.html > > Mr. Black, is that a tactful hint that the original poster should rewrite > his app in C rather than PHP? > > (Not that I’d disagree—not at all!—just wanted to clarify, since o.p.’s > problem originated with SQL core function length() which “returns the > length of X in characters if X is a string, or in bytes if X is a > blob”[1].) > > [1] http://www.sqlite.org/lang_corefunc.html > > (P.S.—For precision, the quoted doc should say “text value” rather than > “string”.) > > Very truly, > > Samuel Adam ◊ <http://certifound.com/> > 763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ United States > Legal advice from a non-lawyer: “If you are sued, don’t do what the > Supreme Court of New Jersey, its agents, and its officers did.” > http://www.youtube.com/watch?v=iT2hEwBfU1g > > >> >> Michael D. Black >> Senior Scientist >> NG Information Systems >> Advanced Analytics Directorate >> >> >> >> ________________________________________ >> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] >> on behalf of Yves Goergen [nospam.l...@unclassified.de] >> 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" <nospam.l...@unclassified.de> >> Visit my web laboratory at http://beta.unclassified.de >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
