The CREATE DATABASE IF NOT EXISTS CMS default charset utf8 COLLATE utf8_general_ci;
USE the CMS;

The SET GBK NAMES;
The CREATE TABLE IF NOT EXISTS cms_admin (
Id TINYINT UNSIGNED AUTO_INCREMENT KEY,
The username VARCHAR (20) NOT NULL UNIQUE
);

The SET GBK NAMES;
The CREATE TABLE IF NOT EXISTS cms_admin (
Id TINYINT UNSIGNED AUTO_INCREMENT KEY,
The username VARCHAR (20) NOT NULL UNIQUE
);

Insert into cms_admin (username) values (' bosses');



The same statement, in the home computer test can show Chinese, can't, what went wrong?

CodePudding user response:

Change GBK to utf8 give it a try

CodePudding user response:

With GBK also not line, don't understand what is the problem the

CodePudding user response:

In utf8 also not