> 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'
Maybe the following? SELECT quote(cast(X'5445' || X'5354' as blob)); Pavel On Fri, Jan 20, 2012 at 4:23 AM, Ivan Shmakov <oneing...@gmail.com> wrote: > 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 > 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
