duzhanfei opened a new issue #7950:
URL: https://github.com/apache/shardingsphere/issues/7950
**Now I connect sharding-Proxy via Navicat. When inserting data, the Chinese
code will be displayed, and when adding tables, the Chinese annotation will
also be displayed. How to set this**
Log information is as follows：
[INFO ] 08:58:17.476 [ShardingSphere-Command-10] ShardingSphere-SQL - Actual
SQL: ds_1 ::: show tables
[INFO ] 08:58:17.477 [ShardingSphere-Command-10] ShardingSphere-SQL - Actual
SQL: ds_2 ::: show tables
line 1:6 no viable alternative at input 'ALTERDATABASE'
line 1:6 no viable alternative at input 'ALTERDATABASE'
[ERROR] 09:07:26.389 [ShardingSphere-Command-11]
o.a.s.s.f.c.CommandExecutorTask - Exception occur:
org.apache.shardingsphere.sql.parser.exception.SQLParsingException:
Unsupported SQL of `ALTER DATABASE `sharding_db` CHARACTER SET utf8 COLLATE
utf8_genera;`
at
org.apache.shardingsphere.sql.parser.core.parser.SQLParserExecutor.execute(SQLParserExecutor.java:49)
at
org.apache.shardingsphere.sql.parser.SQLParserEngine.parse0(SQLParserEngine.java:79)
at
org.apache.shardingsphere.sql.parser.SQLParserEngine.parse(SQLParserEngine.java:61)
at
org.apache.shardingsphere.shardingproxy.backend.text.TextProtocolBackendHandlerFactory.newInstance(TextProtocolBackendHandlerFactory.java:69)
at
org.apache.shardingsphere.shardingproxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.<init>(MySQLComQueryPacketExecutor.java:70)
at
org.apache.shardingsphere.shardingproxy.frontend.mysql.command.MySQLCommandExecutorFactory.newInstance(MySQLCommandExecutorFactory.java:70)
at
org.apache.shardingsphere.shardingproxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandExecutor(MySQLCommandExecuteEngine.java:59)
at
org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:92)
at
org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:71)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
----------------------------------------------------------------
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]
