mysql会话连接字符集,MySQL连接字符集问题

我在Mac上使用带有MySQL的velosurf,没有任何编码问题,但是当我切换到Linux计算机时,从velosurf获得的值未正确编码.

我发现默认连接字符集可能存在问题.在Mac上,我得到了：

mysql> show variables like "collation_%";

+----------------------+-------------------+

| Variable_name | Value |

+----------------------+-------------------+

| collation_connection | utf8_general_ci |

| collation_database | utf8_general_ci |

| collation_server | latin1_swedish_ci |

+----------------------+-------------------+

3 rows in set (0.00 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 | latin1 |

| character_set_system | utf8 |

| character_sets_dir | /usr/local/mysql-5.5.11-osx10.6-x86_64/share/charsets/ |

+--------------------------+--------------------------------------------------------+

8 rows in set (0.00 sec)

在linux机器上,我有：

mysql> show variables like 'collation_%';

+----------------------+-------------------+

| Variable_name | Value |

+----------------------+-------------------+

| collation_connection | latin1_swedish_ci |

| collation_database | utf8_general_ci |

| collation_server | latin1_swedish_ci |

+----------------------+-------------------+

3 rows in set (0.00 sec)

mysql> show variables like 'character_set_%';

+--------------------------+----------------------------+

| Variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | latin1 |

| character_set_connection | latin1 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | latin1 |

| character_set_server | latin1 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.00 sec)

创建数据库时将设置数据库排序规则和字符集.我的问题是我无法更改客户端/连接/结果的默认字符集.

另外,启动连接时似乎没有任何方法用velosurf设置字符集.

有什么建议么？

解决方法:

MySQL有一个命令行标志来设置字符集.你可以试试看吗？ –default-character-set = utf8

标签：character-encoding,connection,mysql

来源： https://codeday.me/bug/20191102/1992035.html