title: How to display blob value using x'abc' binary string literal syntax?
body: <p>You can easily enter a blob value using the x'abc' syntax, but is there a way to display it that way too? As shown below, selecting directly, or implicitly converting to a string using concatenation doesn't work, and shows garbage (Windows DOS prompt here).</p>
  
  <pre><code>sqlite&gt; create table blobs (uid blob);
  sqlite&gt; insert into blobs values (x'0123456789abcdef0123456789abcdef');
  sqlite&gt; select * from blobs;
  ☺#Egë½═∩☺#Egë½═∩
  sqlite&gt; select ''||uid from blobs;
  ☺#Egë½═∩☺#Egë½═∩
  </code></pre>
  
  <p>I'd like the select to display:</p>
  
  <pre><code>x'0123456789abcdef0123456789abcdef'
  </code></pre>
  
  <p>Thanks, --DD</p>