Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

RC1 proxy docker image, Chinese garbled #2890

Closed
ningyu1 opened this issue Aug 19, 2019 · 7 comments
Closed

RC1 proxy docker image, Chinese garbled #2890

ningyu1 opened this issue Aug 19, 2019 · 7 comments
Assignees

Comments

@ningyu1
Copy link

ningyu1 commented Aug 19, 2019

Bug Report

environment: hub.docker sharding-proxy:4.0.0-RC1

problem

Query result Chinese garbled. log print sql normal.
Real database encoding: UTF8MB4.
Real database executes insert, select, and the result character is correct. Garbled after proxy.

Screen

image
image
image

@tuohai666
Copy link
Member

Can you show me the mysqld configuration?

What if you execute these SQLs directly to MySQL?

@ningyu1
Copy link
Author

ningyu1 commented Aug 19, 2019

@tuohai666

What if you execute these SQLs directly to MySQL?
yes

mvn clean install -Prelease -> build RC2 windows testing ,The same problem

@tuohai666
Copy link
Member

I mean what will happen if you execute these SQLs directly to MySQL?

@tuohai666
Copy link
Member

If these SQLs are executed correctly, please add these parameters in jdbcurl of Sharding-Proxy's conf file:
useUnicode=true&characterEncoding=UTF-8&character_set_server=utf8mb4

@ningyu1
Copy link
Author

ningyu1 commented Aug 19, 2019

@tuohai666 tks
The problem is the problem with the mysql server character set
RC2 has been tested and passed
RC1 test it later

@tuohai666
Copy link
Member

Right. At first I doubt the mysql service conf.
More information about the character set please refer to: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-charsets.html.

@ningyu1
Copy link
Author

ningyu1 commented Aug 19, 2019

@tuohai666 thanks.
this issue I closed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants