You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/06/16 10:42:23 UTC
[GitHub] [shardingsphere] lonelythinker commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
lonelythinker commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-644684853
mysql error:ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
This error is reported by mysql server, because the sql has an extra character ')' at the end.
The error sql is generated by ShardingSphere-SQL, when it contains emoji. So it can't be mysql that's causing this problem.(The character set for the mysql database is utf8mb4.)
----------------------------------------------------------------
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:
users@infra.apache.org