<p>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:</p>
<pre><code>select hex(key), hex(value) from main;
</code></pre>

CC BY-SA 4.0
2022-02-12T18:14:35.723Z
2022-02-12T18:14:35.723Z
Ava Chow
<p>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?</p>

<wallet.dat><database>
explore sqlite wallet
Mercedes
# explore sqlite wallet

(Asked by: username_0 on 2022-01-20)

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?

**Tags:** wallet.dat, database


---

## 1 answers

### Answer by username_1 on 2022-02-12. Score: 4 | Accepted answer

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;


---

