title: how to properly store and display unicode in mysql
body: <p>i have installed WAMP in my laptop &amp; i have created a mysql table</p>
  
  <pre><code>CREATE TABLE `users` (
    `uname` varchar(20) NOT NULL,
    `pass` varchar(20) DEFAULT NULL,
    PRIMARY KEY (`uname`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>the column property of the table is shown here
  <a href="https://i.stack.imgur.com/087OZ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/087OZ.jpg" alt="enter image description here"></a>
  when i insert a hindi unicode using </p>
  
  <pre><code>SET NAMES utf8;
  insert into users(uname, pass) values ('सूरज','abc');
  </code></pre>
  
  <p>the content of the table is shown here</p>
  
  <p><a href="https://i.stack.imgur.com/WLLvD.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WLLvD.jpg" alt="enter image description here"></a></p>
  
  <blockquote>
    <p>the unicode word सूरज does not shown properly. where i have done wrong ?</p>
  </blockquote>