SQLite Forum

Feature request: sqlite CLI allow `.mode line` and `.mode quote` together
Login
Hi, Bokwoon,

You may well be aware of this, but for immediate relief, you can use hex():

<pre>   SELECT hex(site_id), domain, subdomain FROM sites;</pre>




To format the UUID, you can of course insert hyphens as in 

[](https://stackoverflow.com/questions/47550860/is-it-possible-to-convert-a-sqlite-blob-column-to-a-hex-string-guid)

If you're using standard formats, you might have to consider endianness and variants.

[](https://neosmart.net/blog/2018/converting-a-binary-blob-guid-to-text-in-sql/)