On Thu, 28 Mar 2013 17:55:00 +0100 Stephan Beal <sgb...@googlemail.com> wrote:
> On Thu, Mar 28, 2013 at 11:33 AM, Francesco Montorsi < > francesco.monto...@embit.it> wrote: > > The docs only say: > > BLOB literals are string literals containing hexadecimal data > > and preceded by a single "x" or "X" character > > > > The encoding is not (or shouldn't be!) done by the client, but by the > sqlite internals, so there is generally no need to concern oneself > with the number of bytes in the blob's encoded representation. Each > byte of input to sqlite3_bind_blob() is internally converted to two > hex bytes, but clients still work with normal bytes, not the encoded > form. sqlite> select x'40'; x'40' ---------- @ sqlite> select x'400'; SQL error: unrecognized token: "x'400'" Hexadecimal string literals must consist of pairs of digits only. I believe Francesco's point is that that fact is not expressed in the documentation. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
