With substr (), it's possible to split a BLOB, like:
SELECT quote (substr (X'1337cafe', 3, 2));
=> X'CAFE'
However, how do I concatenate two blobs?
Unfortunately, the string concatenation operator, when applied
to two BLOB's, results in a text string instead of a BLOB, like:
SELECT quote (X'5445' || X'5354');
=> 'TEST'
--
FSF associate member #7257
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
