title: Inserting hex value in MySQL
body: <p>I have created an SQL database using Java. I have a table created which has two columns, the first being a big integer which increments, the second I have tried defining it as a char, varchar and binary.</p>
  <p>But I'm still not getting the desired functionality. Say I try and store a hex number <code>0a</code> into the char column and I get an error. I appended <code>0x</code> to the beginning and it seems to store, but when I print out the contents it is blank. Or in some cases I get characters such as '/' or '?'. I also tried using SQL explorer and it gives me the same result viewing the table,</p>
  <p>My problem is I need to store an eight character <em>hex string</em> such as <code>eb8d4ee6</code>.</p>
  <p>Could someone please advise me of how this can be done?</p>