title: Cannot insert chinese in mysql database through utf8 encoding ( Warning 1336 incorrect string value)
body: <p>I cannot insert Chinese in the table. I have already config the charset and collation as <em>utf8</em> and <em>utf8_general_ci</em>. The database and table is created as utf8. </p>
  
  <p>Also, I have tried charset as <em>utf8mb4</em> and collation as <em>utf8_unicode_ci</em>, <em>utf8mb4_general_ci, utf8mb4_unicode_ci</em>. All of them point to same error : <em>warning 1366 Incorrect String value</em>.</p>
  
  <p>Big5 and GBK encoding work in this case but I would like to use utf8, as simplified, traditional chinese will be allow to insert.</p>
  
  <p><em>some of the code in mysql:</em></p>
  
  <pre><code>    create database db1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  
      create table table1 (
      lastName varchar(255),
      firstName varchar(255)
      ) ENGINE = MYISAM CHARSET=utf8 COLLATE utf8_general_ci;
  
      INSERT INTO table1 VALUES ('陳','小文');
  
    Warning | 1366 | Incorrect string value: '\xB3\xAF' for column 'lastName' at r
  w 1       |
   Warning | 1366 | Incorrect string value: '\xA4p\xA4\xE5' for column 'firstName
   at row 1 |
  </code></pre>
  
  <p><em>configuration in my.ini</em>:</p>
  
  <pre><code>[client]
  default-character-set=utf8
  [mysqld]
  default-storage-engine=MyISAM
  collation-server=utf8_general_ci
  init-connect='SET NAMES utf8'
  character-set-server=utf8
  skip-character-set-client-handshake=1
  [mysql]
  default-character-set=utf8
  </code></pre>
  
  <p>Using Mysql 5.6.8 version. </p>