请教查看mysql中database以及table的默认字符集的方法 F:\mysql\data\ceshiceshi\db.opt数据库的字符集在这个文件里 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用以下的命令:查看服务器和客户端字符集mysql> show variables like "%char%";+--------------------------+------------------------------------+| 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 | D:\MySQL\MySQL 5.0\share\charsets\ |+--------------------------+------------------------------------+8 rows in set (0.09 sec)mysql> show variables like "%colla%";+----------------------+-----------------+| Variable_name | Value |+----------------------+-----------------+| collation_connection | utf8_general_ci || collation_database | utf8_general_ci || collation_server | utf8_general_ci |+----------------------+-----------------+3 rows in set (0.00 sec)查看数据库的字符集mysql> show create database test;+----------+---------------------------------------------------------------+| Database | Create Database |+----------+---------------------------------------------------------------+| test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8 */ |+----------+---------------------------------------------------------------+1 row in set (0.00 sec)查看表的字符集,包括各个字段的字符集,如果各字段没有标明,表示与表的字符集一致mysql> show create table books \G*************************** 1. row *************************** Table: booksCreate Table: CREATE TABLE `books` ( `id` varchar(8) NOT NULL default '', `name` varchar(24) NOT NULL default '', `title` varchar(96) NOT NULL default '', `price` float NOT NULL default '0', `yr` int(4) unsigned NOT NULL default '0', `description` varchar(30) NOT NULL default '', `saleAmount` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=gbk1 row in set (0.01 sec) 急,union all 使用出错??? mysql 导入 excel 字段 长度 超过 255 HQL问题 如何查看mysql数据库所占的空间 通过附加层访问mysql mysql的查询问题,有关select .... where ..in ()的 为什么我在导入sql脚本的时候出现一长串的帮助信息 哪位仁兄,帮忙介绍一下mysql中,host表和columns_priv表的作用? 用snort+mysql+acid做的入侵检测,数据写不到库里去,求解。 mysql的一点小问题 请教,在MySQL库中已知表名的情况下,如何取得这个表有多少个字段,字段名是什么? MySQL初学者提问
查看服务器和客户端字符集
mysql> show variables like "%char%";
+--------------------------+------------------------------------+
| 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 | D:\MySQL\MySQL 5.0\share\charsets\ |
+--------------------------+------------------------------------+
8 rows in set (0.09 sec)mysql> show variables like "%colla%";
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)查看数据库的字符集
mysql> show create database test;
+----------+---------------------------------------------------------------+
| Database | Create Database |
+----------+---------------------------------------------------------------+
| test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+---------------------------------------------------------------+
1 row in set (0.00 sec)查看表的字符集,包括各个字段的字符集,如果各字段没有标明,表示与表的字符集一致
mysql> show create table books \G
*************************** 1. row ***************************
Table: books
Create Table: CREATE TABLE `books` (
`id` varchar(8) NOT NULL default '',
`name` varchar(24) NOT NULL default '',
`title` varchar(96) NOT NULL default '',
`price` float NOT NULL default '0',
`yr` int(4) unsigned NOT NULL default '0',
`description` varchar(30) NOT NULL default '',
`saleAmount` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk
1 row in set (0.01 sec)