I created an sqlite wallet, tried to browse it from the sqlite3 program, but had to reset (tset) the terminal after querying the main table garbled the console characters. How to query the main table while protecting the terminal?

1 Answer 1


The data stored is binary data, which is why it comes out garbled. It is not text. So you will have to convert the data to something human readable. One such method is to convert it to hex. One such query to do that is:

select hex(key), hex(value) from main;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.