Hello,

when using a blob column in the command line tool 'sqlite3' im getting garbled output when selecting from a table that contains a blob column.

Is there a way to get the blob column output in escaped format, like its used in the insert statement?

Example:

$ sqlite3
SQLite version 3.3.17
Enter ".help" for instructions
sqlite> create table t (x blob);
sqlite> insert into t values (X'ccaaffee');
sqlite> select * from t;
<some garbage displayed here>
sqlite>

I would like to see the X'ccaaffee' again as result of the 'select'.

Regards

Guido

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to