title: how to save currency symbol unicode in mysql table
body: <p>I'm using mysql table to store currency symbol unicode but when I return it to my android app in dto it showing the same unicode string(<strong>\u20B9</strong>) and not the currency sign(<strong>₹</strong>).</p>
  
  <p>Earlier I was using it hard coded like <code>dto.setCurrencyCode("\u20B9")</code> and it was working fine but its not working if I fetch it from mysql table and set in dto.</p>
  
  <p>The mysql table charset is like -</p>
  
  <pre><code>+--------------+--------------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
  | Field        | Type         | Collation       | Null | Key | Default | Extra          | Privileges                      | Comment |
  +--------------+--------------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
  | id           | bigint(20)   | NULL            | NO   | PRI | NULL    | auto_increment | select,insert,update,references |         |
  | apiUrl       | varchar(255) | utf8_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
  | countryCode  | varchar(255) | utf8_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
  | currencyCode | varchar(255) | utf8_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
  | locale       | varchar(255) | utf8_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
  | mcc          | int(11)      | NULL            | NO   | MUL | NULL    |                | select,insert,update,references |         |
  | msisdnLength | int(11)      | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
  +--------------+--------------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
  </code></pre>
  
  <p>and table entry is like -</p>
  
  <pre><code>mysql&gt; select * from MccDetails;
  +----+-------------------------------------+-------------+--------------+--------+-----+--------------+
  | id | apiUrl                              | countryCode | currencyCode | locale | mcc | msisdnLength |
  +----+-------------------------------------+-------------+--------------+--------+-----+--------------+
  |  1 | https://localhost:8080/api/         | +91         | \u20B9       | en     | 404 |           10 |
  |  2 | https://localhost:8080/api/         | +91         | \u20B9       | en     | 405 |           10 |
  +----+-------------------------------------+-------------+--------------+--------+-----+--------------+
  </code></pre>
  
  <p>This is my connection string -
  <code>jdbc:mysql://127.0.0.1:3306/dbname?autoReconnect=true&amp;useUni‌​code=true&amp;connection‌​Collation=utf8_gener‌​al_ci&amp;characterSetRe‌​sults=utf8</code></p>
  
  <p>Please let me know what should be the data type of <code>currencyCode</code> column and how to store the unicode value (\u20B9) in table or what is the best way to handle currency symbol in client server architecture.</p>