dbeaver / dbeaver/dbeaver

Garbled Chinese characters

Open
#22,342 15 comments 0 reactions 0 assignees View on GitHub
wait for votes x:mysql xf:data xf:encoding
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

### Description

MySQL表中的数据在命令行查询乱码,在查询之前需要执行`set character_set_results=latin1;`然后执行查询语句,这时中文显示正常。在Navicat执行set后查询数据也是正常,但是在dbeaver执行set之后再次查询换了一个其他的乱码。

**数据库和表设置的编码都是utf8**

### 执行set character_set_results=latin1之前
![image](https://github.com/dbeaver/dbeaver/assets/35440977/7818c955-f88b-4104-807c-2b2f21fdbf7a)
### 执行set character_set_results=latin1之后
![image](https://github.com/dbeaver/dbeaver/assets/35440977/88d11be7-b927-4822-a6bb-7be66b048e1b)

Navicat和命令行执行后正确显示中文。

### DBeaver Version

Community Edition 23.2.5.202311191730

### Operating System

win和mac一样

### Database and driver

MySQL5.7.33

### Steps to reproduce

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.