title: MySQL output hex string as UTF-8
body: <p>This works UTF8</p>
  
  <pre><code>create temporary table test (x char(1) not null) charset=utf8;
  insert into test select x'c3a9';
  select hex(x), x from test;
  drop table test;
  </code></pre>
  
  <p>outputs</p>
  
  <pre><code>+--------+---+
  | hex(x) | x |
  +--------+---+
  | C3A9   | é | 
  +--------+---+
  </code></pre>
  
  <p>But this uses the default charset which is not utf8</p>
  
  <pre><code>SELECT x'c3a9';
  </code></pre>
  
  <p>How can I change the above one-liner to output UTF-8 <code>é</code> instead of <code>Ã©</code>?</p>