如下,`sname`列我在数据库里放了中文,在这里显示不出来?Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.1.30-community MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> use test;
Database changed
mysql> select*from student;
+-----+-----------+
| sid | sname |
+-----+-----------+
| 1 | |
| 2 | |
| 3 | |
+-----+-----------+
3 rows in set (0.00 sec)而且这里也显示utf8,到底是哪里出问题了?
mysql> show variables like'character%';
+--------------------------+----------------------------------------------------
-----------+
| Variable_name | Value
|
+--------------------------+----------------------------------------------------
-----------+
| character_set_client | utf8
|
| character_set_connection | utf8
|
| character_set_database | utf8
|
| character_set_filesystem | binary
|
| character_set_results | utf8
|
| character_set_server | utf8
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files (x86)\MySQL\MySQL Server 5.1\share
\charsets\ |
+--------------------------+----------------------------------------------------
-----------+
8 rows in set (0.00 sec)
Your MySQL connection id is 11
Server version: 5.1.30-community MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> use test;
Database changed
mysql> select*from student;
+-----+-----------+
| sid | sname |
+-----+-----------+
| 1 | |
| 2 | |
| 3 | |
+-----+-----------+
3 rows in set (0.00 sec)而且这里也显示utf8,到底是哪里出问题了?
mysql> show variables like'character%';
+--------------------------+----------------------------------------------------
-----------+
| Variable_name | Value
|
+--------------------------+----------------------------------------------------
-----------+
| character_set_client | utf8
|
| character_set_connection | utf8
|
| character_set_database | utf8
|
| character_set_filesystem | binary
|
| character_set_results | utf8
|
| character_set_server | utf8
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files (x86)\MySQL\MySQL Server 5.1\share
\charsets\ |
+--------------------------+----------------------------------------------------
-----------+
8 rows in set (0.00 sec)
解决方案 »
- mysql_free_result
- 某大公司面试题
- 如何向两个关联的数据表插值啊
- postgres如何写存储过程,望各位帮忙,给一个相关实例
- 世界国家、地区(城市)的数据库
- 请用过mysqlfailover的达人指点下
- 多线程同时调用MySql存储过程的问题
- sql里面如何直接插入blob数据
- 相同的数据,在本地执行很快 服务器上执行很慢 是什么原因
- SQLSTATE[HY000] [1045] Access denied for user 'root'@'120.92.161.238' (using pas
- 按月份统计每个合同累计到当月的回款数据?
- 新手请教关于mysql的分支mariadb安装后启动的问题
英文的可以,就是中文的有问题看看字符集设置的是不是utf-8