MYSQL支持汉字？？？？？？

zlb527

我是用上位机的软件来操作MYSQL，我把字段写成英文或数字都可以在MYSQL里建表，但当我把字段改成汉字时，就会提示我一个错误，请各位帮忙看看，我是哪出了问题！是不是MYSQL要支持汉字，还得装什么软件呀！

zlb527

：
you hare an erro in your SQL syntax near 'NUMERIC,张 NUMERIC)'
at line 1
谢谢了

redfox

老大，不要用中文了。

zlb527

不行呀，我必须要用到中文呀，帮我想想办法吧，谢了！

ailms

整个create命令贴出来

zlb527

drop database if exists school;
create database school;
use school;
create table teacher
(
id int(3) auto_increment not null primary key,
name char(10) not null,
address varchar(50) default 深圳,
year date
);
insert into teacher valuess(,glchengang,深圳一中,1976-10-10);
insert into teacher valuess(,jack,深圳一中,1975-12-23);

zlb527

[root@localhost] ERROR 1064: You have an error in your SQL syntax near '
year date
)' at line 5
[root@localhost] ERROR 1064: You have an error in your SQL syntax near 'valuess(,glchengang,É&ÛÚÒ&ÖÐ,1976-10-10)' at line 1
[root@localhost] ERROR 1064: You have an error in your SQL syntax near 'valuess(,jack,É&ÛÚÒ&ÖÐ,1975-12-23)' at line 1

zlb527

好像是汉字系统出了问题，各们大侠快帮帮我呀，我做的是本站提供给的例子。

zlb527

[quote]原帖由 "zlb527"]好像是汉字系统出了问题，各们大侠快帮帮我呀，我做的是本站提供给的例子。[/quote 发表：
      

caojiqun

create table teacher
(
id int(3) auto_increment not null primary key,
name char(10) not null,
address varchar(50) default '深圳',
year date
);
insert into teacher valuess(,glchengang,'深圳一中','1976-10-10');
insert into teacher valuess(,jack,'深圳一中','1975-12-23');