When PHP builds a table, how to add the connection proofreading to the Chinese text section?

In order to solve the problem of character garbled, I was told to build the table when the text field plus a connection to proofread gbk_chinese_ci or utf8_general_ci
Tell MySQL what character set to store the data in.

Want to know how to add the concrete? Thank you

Reply to discussion (solution)

Like what
CREATE TABLE ' Tb_userinfo ' (
' ID ' int (a) is not NULL auto_increment,
' username ' varchar (CHARACTER) SET UTF8 DEFAULT NULL,
' Password ' varchar DEFAULT NULL,
' Email ' varchar DEFAULT NULL,
PRIMARY KEY (' id ')
) Engine=innodb auto_increment=90 DEFAULT charset=latin1

Beginners can use graphical tools such as phpMyAdmin to choose

It's a little clear, thank you.

