sql component garbled

[ljl0303]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

ds2.0.6 mysql5.7 使用sql组件,查询带有例如select "中文";结果乱码,更换mysql8不乱码

What you expected to happen

乱码肯定是不对的

How to reproduce

mysql5.7使用sql组件,select内直接使用中文常量

Anything else

每次

Version

2.0.x

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

ds2.0.6 mysql5.7 use sql component, the query contains for example select "Chinese"; the result is garbled, replace mysql8 without garbled

What you expected to happen

The garbled code is definitely wrong

How to reproduce

MySQL 5.7 uses sql components, and Chinese constants are used directly in select

Anything else

every time

Version

2.0.x

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

Thank you for your feedback, we have received your issue, Please wait patiently for a reply.

• In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
• If you haven't received a reply for a long time, you can join our slack and send your question to channel #troubleshooting

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

[brave-lee]

I tested that this function is OK. Please check your data source configuration and see if you haven't added jdbc parameters, such as {"useUnicode":"true","characterEncoding":"UTF-8"}