>>>>> Pavel Ivanov writes:
[...]
>> 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));
Indeed, it seems to work. Thanks!
--
FSF associate member #7257
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
