dafanzhi opened a new issue #8656:
URL: https://github.com/apache/shardingsphere/issues/8656


   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   5.0.0-alpha
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   The Chinese chars should be stored normally into a utf8 database after doing 
an UPDATE sql.
   
   ### Actual behavior
   The Chinese chars is converted to ??
   
   ### Reason analyze (If you can)
   By default, the characterEncoding param in the url is set to GBK.
   When i specified the  characterEncoding is utf8 in the url like follows, the 
issue is resovled:
   ```
   url: 
jdbc:mysql://47.99.192.24:3306/enhancer_project_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf8
   ```
   
   So, it is strongly recommended to set the value of utf8 for the 
characterEncoding by default and provide more explicit  configuration document 
for each props in config-xxx.yaml.
   
   Thanks in advance. 
   
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to