linux服务器上mysql的字符集设置是+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+本地安装的mysql上目前的设置是character_set_client utf8
character_set_connection latin1
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8试着修改 my.cnf 文件 在 [mysqld] 下添加default-character-set = utf8可以改变 character_set_database utf8
character_set_server utf82项 但是其他变量无论我怎么设置都修改不了默认设置请教高手如何才能修改默认设置
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+本地安装的mysql上目前的设置是character_set_client utf8
character_set_connection latin1
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8试着修改 my.cnf 文件 在 [mysqld] 下添加default-character-set = utf8可以改变 character_set_database utf8
character_set_server utf82项 但是其他变量无论我怎么设置都修改不了默认设置请教高手如何才能修改默认设置
default-character-set = utf8
MySQL 中文显示乱码上贴中有关于字符集的介绍。
character_set_client utf8 // 你客户端
character_set_connection latin1 //客户端
character_set_database latin1 //数据库本身
character_set_filesystem binary //文件系统
character_set_results utf8 // 服务器
character_set_server latin1 // 服务器
character_set_system utf8 //服务器
你可以用 set names 'utf8' 来临时设置。
貌似没有my.ini文件 在 [client] 下添加
default-character-set = utf8 试过了 还是不行