只需要输入时charsetgbk就ok了简单易 *** 作,别问我怎么知道的,百度是个好东西。此外,还有一个问题就是怎么把中文正常显示。
我的可以mysql> desc studentinfo
+-------------+----------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------------------------+------+-----+---------+-------+
| sno | int(8) | NO | PRI | NULL | |
| sex | enum('男','女') | NO | | NULL | |
| age | int(3) | YES | | NULL | |
| identify | varchar(18) | NO | UNI | NULL | |
| tel | varchar(15) | YES | | NULL | |
| car_type | varchar(4) | NO | | NULL | |
| enroll_time | date | NO | | NULL | |
| leave_time | date | YES | | NULL | |
| scondition | enum('学习','结业','退学') | NO | | NULL | |
| s_text | text | YES | | NULL | |
+-------------+----------------------------+------+-----+---------+-------+
10 rows in set (0.00 sec)
mysql> show variables
+-----------------------------------------+---------------------------------------------------------------------
| Variable_name | Value
+-----------------------------------------+---------------------------------------------------------------------
| auto_increment_increment | 1
| auto_increment_offset | 1
| autocommit | ON
| automatic_sp_privileges | ON
| back_log | 50
| basedir | D:\Program Files\MySQL\MySQL Server 5.1\
| big_tables | OFF
| binlog_cache_size | 32768
| binlog_direct_non_transactional_updates | OFF
| binlog_format | STATEMENT
| bulk_insert_buffer_size | 8388608
| character_set_client | gbk
| character_set_connection | gbk
| character_set_database | utf8
| character_set_filesystem | binary
| character_set_results | gbk
| character_set_server | utf8
| character_set_system | utf8
| character_sets_dir | D:\Program Files\MySQL\MySQL Server 5.1\share\charsets\
| collation_connection | gbk_chinese_ci
| collation_database | utf8_general_ci
| collation_server | utf8_general_ci
| completion_type | 0
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)