Linux环境下默认登录mysql之后show variables like "%character%", 出现mysql> show variables like "%character%";+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
修改/etc/mysql/my.cnf在[client]下增加default-character-set=utf8
在[mysqld]下增加default-character-set=utf8同时加上init_connect="SET NAMES utf8" (设定连接mysql数据库时使用utf8编码,以让mysql数据库为utf8运行)重新启动mysql,执行:sudo /etc/init.d/mysql stop 然后sudo /etc/init.d/mysql startmysql> 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 | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
即使做了以上修改如果直接数据库再创建表,然后存入中文,取出来的会是问号。解决的办法是:创建数据库的时候指明默认字符集为utf8,如:
create database test default character set utf8; 在Linux系统上安装64位Oracle遇到的几个问题在Linux下使用源代码安装PostgreSQL步骤相关资讯 linux mysql MySQL教程
- 30分钟带你快速入门MySQL教程 (02月03日)
- MySQL教程:关于I/O内存方面的一些 (01月24日)
- Linux开启MySQL远程连接 (11/22/2014 07:40:48)
| - MySQL教程:关于checkpoint机制 (01月24日)
- Linux下MySQL的简单操作笔记 (08/12/2015 10:50:28)
- Linux下MySQL报Table "xxx" doesn" (11/22/2014 07:37:47)
|
本文评论 查看全部评论 (0)