title: chinese character in mysql insert and phpmyadmin
body: <p>i have this chinese character which i want to insert into database and browser output in correct but when data is inserted into mysql it is in different format something like this.</p>
  
  <p>my chinese characters</p>
  
  <p>图片库,高清图片大全,图库</p>
  
  <p>and inserted into database is </p>
  
  <p>å›¾ç‰‡åº“,é«˜æ¸…å›¾ç‰‡å¤§å…¨,å›¾åº“</p>
  
  <p>i have tried several things like setting utf8</p>
  
  <pre><code>     mysql_set_charset("utf8", $connection);
  </code></pre>
  
  <p>then chenaged the collation from swidish to utf general</p>
  
  <p>then checked the details with this command which proved that my charcter is correctly set to utf8</p>
  
  <pre><code>   SHOW CREATE TABLE tablea;
  
     CREATE TABLE `tablea` (
     `id` int(12) NOT NULL AUTO_INCREMENT,
     `tiya` text CHARACTER SET utf8 NOT NULL,
     PRIMARY KEY (`id`),
    ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
  </code></pre>
  
  <p>can anyone suggest where to solve chinese charracter issue .my insert is this </p>
  
  <pre><code>         mysqli_query ($con,"INSERT INTO tablea (tiya) VALUES ('$tit')");
  </code></pre>