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 2021/10/21 08:04:25 UTC
[GitHub] [shardingsphere] duansy123 opened a new issue #13198: Query Emoji's questions
duansy123 opened a new issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198
The data obtained by querying the fields with emoji expressions becomes "?"
But not every time it’s "?" It is occasionally possible to successfully display emoji
The character sets of all libraries and tables are unified utf8mb4
The character set of the linked database is also set &character_set_server=utf8mb4&connectionCollation=utf8mb4_bin
Please help to solve this problem
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949338958
> > Now I don’t have mysql service locally, can I start it locally if the mysql service is on other machines?
>
> Sure, database server can on any host.
But I still report the error in the screenshot above when I set up other hosts, and that ip is my local
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949331441
Do I have to have a MySQL service locally?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-948385740
> 嗨@duansy123 请参考此评论： [#13023（评论）](https://github.com/apache/shardingsphere/issues/13023#issuecomment-944348159)
Hello, it has been configured according to this, but it still does not work, please help provide other solutions
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-950715476
Wow, a special case. thank you for your feedback.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 edited a comment on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 edited a comment on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949319959
> SCHEMA_PRIVILEGES_PERMITTED:#10998
Please take a look at my configuration and always report this error when starting up
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949334488
> Do I have to have a MySQL service locally?
Yes, you should have a schema configuration contains datasources.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949335484
Now I don’t have mysql service locally, can I start it locally if the mysql service is on other machines?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-948412531
> > the version is 5.0.0-alpha
>
> Can you try the latest version? 5.0.0-beta or the master branch, I think it was imporved.
ok i will try
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-948389891
> I see that the parameters you added are not complete, please try to add other parameters.
Hi here are all the parameters I added
`
?useUnicode=true&characterEncoding=UTF-8&character_set_server=utf8mb4&connectionCollation=utf8mb4_bin&allowMultiQueries=true`
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949256184
> I am trying but the new version configuration is a bit different, I need time to start it
Yes, there are some differences.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-948362981
Version is 5.0.0
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949351075
Oh okay, please take a look at the startup error first
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-950721435
> @duansy123 So, can we close thie issue?
Of course，thank you！
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949373308
> > > 5.0.0-beta
> >
> >
> > Yes, I am the version 5.0.0-beta and then I replaced it with ALL_PRIVILEGES_PERMITTED and started it up. After testing with emoji, it still doesn’t work, the expression will show "?" Please help to solve it
>
> OK, I will investigate it.
thanks!
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949372087
> > 5.0.0-beta
>
> Yes, I am the version 5.0.0-beta and then I replaced it with ALL_PRIVILEGES_PERMITTED and started it up. After testing with emoji, it still doesn’t work, the expression will show "?" Please help to solve it
OK, I will investigate it.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-950698107
> I'm very sorry, but I have solved this problem by other means. thank you for your reply
Okay, can you tell me the solution?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949361539
> 5.0.0-beta
Yes, I am the version 5.0.0-beta and then I replaced it with ALL_PRIVILEGES_PERMITTED and started it up.
After testing with emoji, it still doesn’t work, the expression will show "?" Please help to solve it
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949312869
SCHEMA_PRIVILEGES_PERMITTED:https://github.com/apache/shardingsphere/pull/10998
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-948411814
> the version is 5.0.0-alpha
Can you try the latest version? 5.0.0-beta or the master branch, I think it was imporved.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949307536
> Here is an example for Proxy: https://github.com/apache/shardingsphere/tree/master/examples/shardingsphere-proxy-example/shardingsphere-proxy-boot-mybatis-example/src/main/resources/conf
How to use authorizedSchemas in the new version?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949319959
> SCHEMA_PRIVILEGES_PERMITTED:#10998
Please take a look at my configuration and always report this error when starting up
`rules:
- !AUTHORITY
users:
- root@%:root
provider:
type: SCHEMA_PRIVILEGES_PERMITTED
props:
max-connections-size-per-query: 1
kernel-executor-size: 16 # Infinite by default.
proxy-frontend-flush-threshold: 128 # The default value is 128.
proxy-opentracing-enabled: false
proxy-hint-enabled: false
sql-show: false
check-table-metadata-enabled: false
`
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-950666350
@duansy123
Since the problem cannot be reproduced, I cannot investigate the problem further here.
If you want, you can create a sample project on github and provide your own table structure and operation SQLs
to help us reproduce the problem. Of course, this is to help you.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-950715808
@duansy123 So, can we close thie issue?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-948384255
Hi @duansy123
Please refer to this comment:
https://github.com/apache/shardingsphere/issues/13023#issuecomment-944348159
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-948407650
> > Version is 5.0.0
>
> `5.0.0` is not existed, can you give the full version?
the version is 5.0.0-alpha
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-948397805
> `JDBC URL for the application connect to the Proxy`和`each JDBC URL for the Proxy to connect to the physical databases`？
Yes, every link includes the above parameters
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-950674521
> @duansy123 Since the problem cannot be reproduced, I cannot investigate the problem further here. If you want, you can create a sample project on github and provide your own table structure and operation SQLs to help us reproduce the problem. Of course, this is to help you.
I'm very sorry, but I have solved this problem by other means. thank you for your reply
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949296637
> > I am trying but the new version configuration is a bit different, I need time to start it
>
> Yes, there are some differences.
Sorry, I try to start the new version, but there are always some problems with the startup. Can you give me a reference if you have a demo version?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang closed issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949255109
> Hi @duansy123 Is it effective?
I am trying but the new version configuration is a bit different, I need time to start it
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-948393982
Including the `JDBC URL for the application connect to the Proxy` and `each JDBC URL for the Proxy to connect to the physical databases`?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-948388492
I see that the parameters you added are not complete, please try to add other parameters.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949305597
Here is an example for Proxy:
https://github.com/apache/shardingsphere/tree/master/examples/shardingsphere-proxy-example/shardingsphere-proxy-boot-mybatis-example/src/main/resources/conf
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-950661707
Hi @duansy123
I made a sharding scene (table `t_order` in sharding databases) and inserted `emoji` into the varchar type column of `t_order`. Then I wrote a client for loop query, all emoji are displayed normally, and there is no abnormality.
#### INSERT
```sql
INSERT INTO t_order (order_id,user_id,status) VALUES(1,1,'test😂');
INSERT INTO t_order (order_id,user_id,status) VALUES(2,2,'test😂');
INSERT INTO t_order (order_id,user_id,status) VALUES(3,3,'test😤😤');
INSERT INTO t_order (order_id,user_id,status) VALUES(4,4,'test😱😱');
INSERT INTO t_order (order_id,user_id,status) VALUES(5,5,'test😀😀');
INSERT INTO t_order (order_id,user_id,status) VALUES(6,6,'test❤️❤️');
```
#### DATA
- ds_0.t_order
- ds_1.t_order
#### QUERY RESULT
#### LOOP QUERY RESULT (10000 times)
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-948395184
> Version is 5.0.0
`5.0.0` is not existed, can you give the full version?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949336244
> Now I don’t have mysql service locally, can I start it locally if the mysql service is on other machines?
Sure, database server can on any host.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] duansy123 commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
duansy123 commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-950704123
> > I'm very sorry, but I have solved this problem by other means. thank you for your reply
>
> Okay, can you tell me the solution?
Of course, I tried to configure the Druid character set parameters `connection-init-sqls: set names utf8mb4`
Then remove the character set setting for connecting to the database. I really tried many times. I don't know if the connection configuration of sharding is overwritten when spring is connected.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949349264
@duansy123 Please provide your datasource configuration, or you may need to read the example again:
https://github.com/apache/shardingsphere/tree/master/examples/shardingsphere-proxy-example/shardingsphere-proxy-boot-mybatis-example/src/main/resources/conf
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949357710
What version are you testing? `SCHEMA_PRIVILEGES_PERMITTED` was added in 5.0.0-beta.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13198: Query Emoji's questions
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13198:
URL: https://github.com/apache/shardingsphere/issues/13198#issuecomment-949254141
Hi @duansy123 Is it effective?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org