finalshell进入数据库的时候显示乱码

女爷i 2022-12-15 12:58 159阅读 0赞

环境Centos7+docker+MySQL8  
如图所示：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NzM5NzA2_size_16_color_FFFFFF_t_70_pic_center]  
解决的方案：  
使用命令查看数据库的字符编码：

show VARIABLES like 'character%';

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NzM5NzA2_size_16_color_FFFFFF_t_70_pic_center 1]修改字符编码为utf8  
\*\* SET character\_set\_results = utf8 ;\*\* （关键）

如果没有效果再试一下下面的设置

mysql> SET character_set_client = utf8 ;  
    
    mysql> SET character_set_connection = utf8 ;   
    
    mysql> SET character_set_database = utf8 ;   
    
    mysql> SET character_set_results = utf8 ;    
    
    mysql> SET character_set_server = utf8 ;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NzM5NzA2_size_16_color_FFFFFF_t_70_pic_center 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NzM5NzA2_size_16_color_FFFFFF_t_70_pic_center 3]  
这样再输出就ok了，  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NzM5NzA2_size_16_color_FFFFFF_t_70_pic_center 4]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NzM5NzA2_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/a4b078f95fd747ec84f8da9b98f86d24.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NzM5NzA2_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221123/a7ce6c981a574e32b095eccb221895fd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NzM5NzA2_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221123/ab6350cf7b6d4450b1927dbad962be00.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NzM5NzA2_size_16_color_FFFFFF_t_70_pic_center 3]: /images/20221123/a95ebae4a934446ebadef6944795efc0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NzM5NzA2_size_16_color_FFFFFF_t_70_pic_center 4]: /images/20221123/a602033504a049eb86b46159a4cbdb85.png