Cannot insert chinese in mysql database through ut

Question

I cannot insert Chinese in the table. I have already config the charset and collation as utf8 and utf8_general_ci. The database and table is created as utf8.

Also, I have tried charset as utf8mb4 and collation as utf8_unicode_ci, utf8mb4_general_ci, utf8mb4_unicode_ci. All of them point to same error : warning 1366 Incorrect String value.

Big5 and GBK encoding work in this case but I would like to use utf8, as simplified, traditional chinese will be allow to insert.

some of the code in mysql:

    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 |

configuration in my.ini:

[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

Using Mysql 5.6.8 version.

Answer 1

CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci set this collation on three places:

1- In database collation under operation or setting tab you can find collation dropbox select "utf8mb4_general_ci" from there.

2- In table again under operation tab you need to change collation value from dropdown for same "utf8mb4_general_ci".

3- Don't forget now to change the collation of your column that hold your data click on structure tab of your table edit the columns that need to be hold Chinese data and change collation for each as same: "utf8mb4_general_ci".

Try to place chinese character directly from phpmyadmin if you can successfully insert chinese character that's means you're done with database then try with server or from your website. If doesn't work from wesbite, Then May you need to add utf 8 meta tag on website script.