【举例】波兰语Śląskie中的Ś和ą字母显示的是?
1.修改配置文件my.ini里的:
default-character-set = utf8
character-set-server = utf8
2.命令行设置:
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\MySQL\MySQL Server 5.5\share\chars
ets\ |
+--------------------------+----------------------------------------------------
-----+
8 rows in set (0.05 sec)
mysql> show variables like 'collation%';
+----------------------+-----------------+
| 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>
3.针对我创建的数据库,设置字符集为utf8:
alter database 数据库名字 character set utf8;
4.数据库表的字符集也是utf8
mysql> show create table customer_info;
+---------------+---------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------+
| Table | Create Table
|
+---------------+---------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------+
| customer_info | CREATE TABLE `customer_info` (
`CUST_ID` int(11) NOT NULL DEFAULT '0',
`CUST_CODE` varchar(32) NOT NULL DEFAULT '',
`CUST_NAME` varchar(100) NOT NULL DEFAULT '',
`CUST_CATE` char(1) DEFAULT 'N',
`CURRENCY` char(3) DEFAULT 'EUR',
`CONTINENT` char(1) DEFAULT 'E',
`REGION` char(2) NOT NULL DEFAULT '',
`PROVINCE` varchar(30) DEFAULT '',
`CITY` varchar(30) DEFAULT '',
`ADDRESS` varchar(150) DEFAULT '',
`ZIP` varchar(10) DEFAULT '',
`EMAIL` varchar(100) DEFAULT '',
`WEBSITE` varchar(100) DEFAULT '',
`LINKMAN` varchar(50) DEFAULT '',
`PHONE` varchar(20) DEFAULT '',
&