MySQL中表的列名是不是不能用中文

Question

在你的 my.ini 文件中加入下面的就可以了
[mysqld]
default-character-set =gb2312

Answer 1

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.0.11-gamma-max-nt-logType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> SHOW VARIABLES LIKE 'character_set';
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| character_set | gb2312 |
+---------------+--------+
1 row in set (0.00 sec)mysql> use test;
Database changed
mysql> SHOW CREATE TABLE `中国`;
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--+
| Table | Create Table  |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--+
| 中国  | CREATE TABLE `中国` (
  `编号` varchar(10) NOT NULL default '',
  `姓名` varchar(8) default NULL,
  `性别` char(2) NOT NULL default '男',
  `年龄` tinyint(3) unsigned default '0',
  `家庭地址` varchar(80) default NULL,
  `备注` longtext,
  PRIMARY KEY  (`编号`),
  KEY `姓名` (`姓名`)
) TYPE=MyISAM COMMENT='rr' |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--+
1 row in set (0.00 sec)mysql>

Answer 2

TO  fsht(呵呵) 看到
mysql> SHOW CREATE TABLE `中国`;
语句的结果你应该相信了吧!!!!!!!!!自己再试一试呢!!!!

Answer 3

mysql> SHOW VARIABLES LIKE 'character_set';
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| character_set | latin1 |
+---------------+--------+
1 row in set (0.01 sec)怎么改character_set 成为gb2312 ？

Answer 4

mysql> SHOW VARIABLES LIKE 'character_set';
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| character_set | latin1 |
+---------------+--------+
1 row in set (0.01 sec)怎么改character_set 成为gb2312 ？?????????????????????????????????????

Answer 5

知道了！在你的 my.ini 文件中加入下面的就可以了
[mysqld]
default-character-set =gb2312再重起服务

Answer 6

mysql> shwo create table '爱护' ;
ERROR 1064: You have an error in your SQL syntax near 'shwo create table '爱护''
 at line 1mysql> show variables like 'character_set' ;
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| character_set | gb2312 |
+---------------+--------+my.ini ：
[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-nt.exe
QueryInterval=10[mysqld]
default-character-set =gb2312