打开navicat客户端工具,在左边找到要更改的数据库。
右键点击这个数据库,在菜单上点击数据库属性选项。
在d出的属性窗口上,点击默认字符集下的下拉框。
在d出的下拉选项里,点击选中要使用的字符集就行了,比如选择常用的utf8字符集,点击ok按钮就行了。
处理方法:打开(OPEN)mysql安装目录:C:\ProgramFiles\MySQL\MySQL
Server
5.5
打开(OPEN)文件my.ini配置文件,找到
default-character-set=latin1
并改为:
default-character-set=gbk,找到
character-set-server=latin1
并改为:
character-set-server=gbk,修改完之后保存。
最后:我的电脑(PC)右击
“管理”进之后选取“服务和应用程序”下的“服务”
找到“mysql”之后右击选取“重新开启”。
把jsp页面中的<%@
page
language="java"
IMPORT="java.util.*"
pageEncoding="ISO-8859-1"%>改为<%@
page
language="java"
IMPORT="java.util.*"
pageEncoding="UTF-8"%>即可
查看字符集设置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.02 sec)
mysql>show variables like 'character_set_%'
+--------------------------+----------------------------+
| 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| /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.02 sec)
mysql>
其他的一些设置方法:
修改数据库的字符集
mysql>use mydb
mysql>alter database mydb character set utf-8
创建数据库指定数据库的字符集
mysql>create database mydb character set utf-8
通过配置文件修改:
修改/var/lib/mysql/mydb/db.opt
default-character-set=latin1
default-collation=latin1_swedish_ci
为
default-character-set=utf8
default-collation=utf8_general_ci
重起MySQL:
[root@bogon ~]# /etc/rc.d/init.d/mysql restart
通过MySQL命令行修改:
mysql>set character_set_client=utf8
Query OK, 0 rows affected (0.00 sec)
mysql>set character_set_connection=utf8
Query OK, 0 rows affected (0.00 sec)
mysql>set character_set_database=utf8
Query OK, 0 rows affected (0.00 sec)
mysql>set character_set_results=utf8
Query OK, 0 rows affected (0.00 sec)
mysql>set character_set_server=utf8
Query OK, 0 rows affected (0.00 sec)
mysql>set character_set_system=utf8
Query OK, 0 rows affected (0.01 sec)
mysql>set collation_connection=utf8
Query OK, 0 rows affected (0.01 sec)
mysql>set collation_database=utf8
Query OK, 0 rows affected (0.01 sec)
mysql>set collation_server=utf8
Query OK, 0 rows affected (0.01 sec)
查看:
mysql>show variables like 'character_set_%'
+--------------------------+----------------------------+
| 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| /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.03 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.04 sec)
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)