MySQL cannot insert Chinese

CREATE TABLE Ordermeg
(
OID Int PRIMARY KEY,
CNAME varchar (NOT NULL),
Receivename varchar () NOT NULL,
Receiveadds varchar () NOT NULL,
Receivetel varchar () NOT NULL,
Allmoney double NOT NULL,
Zhuangtai varchar () Default ' not sent ',
Buytime datetime NOT NULL
);

If you cannot create this table

Invalid default value ...

It's okay to remove the Chinese line.

--------------------------------------------------

Solution:

Modify the character set key values in the MySQL My.ini file,

Modify Character set: C drive

Default-character-set = UTF8 is →gb2312

You can view the character set status;