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 2022/07/21 08:16:12 UTC
[GitHub] [shardingsphere] panqizhen opened a new issue, #19424: how can i set sql-mode through a conf file
panqizhen opened a new issue, #19424:
URL: https://github.com/apache/shardingsphere/issues/19424
## Question
I am using shardingsphere-proxy with php and I need to set mysql sql-mode. now i can only set sql-mode after start shardingsphere-proxy, but it will be invalid after restart. I did not find any method in the docs and i can not understand the source code. How can i set sql-mode durable
**For English only**, other languages will not accept.
Before asking a question, make sure you have:
- Googled your question.
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close 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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] panqizhen commented on issue #19424: how can i set sql-mode through a conf file
Posted by GitBox <gi...@apache.org>.
panqizhen commented on issue #19424:
URL: https://github.com/apache/shardingsphere/issues/19424#issuecomment-1198048836
> Just set it in your database
But i can not remove STRICT_TRANS_TABLES
--
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] panqizhen commented on issue #19424: how can i set sql-mode through a conf file
Posted by GitBox <gi...@apache.org>.
panqizhen commented on issue #19424:
URL: https://github.com/apache/shardingsphere/issues/19424#issuecomment-1210378849
> Just set it in your database
hwo can i change this sql_mode and remove "STRICT_TRANS_TABLES"
--
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] TeslaCN closed issue #19424: how can i set sql-mode through a conf file
Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #19424: how can i set sql-mode through a conf file
URL: https://github.com/apache/shardingsphere/issues/19424
--
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] panqizhen commented on issue #19424: how can i set sql-mode through a conf file
Posted by GitBox <gi...@apache.org>.
panqizhen commented on issue #19424:
URL: https://github.com/apache/shardingsphere/issues/19424#issuecomment-1212629774
> Try setting `jdbcCompliantTruncation=false` in JDBC URL.
>
> Such as
>
> ```
> jdbc:mysql://127.0.0.1:3306/ds?jdbcCompliantTruncation=false
> ```
Thank you very much! It works
--
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] terrymanu commented on issue #19424: how can i set sql-mode through a conf file
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #19424:
URL: https://github.com/apache/shardingsphere/issues/19424#issuecomment-1193574301
Just set it in your database
--
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] TeslaCN commented on issue #19424: how can i set sql-mode through a conf file
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #19424:
URL: https://github.com/apache/shardingsphere/issues/19424#issuecomment-1211673716
Try setting `jdbcCompliantTruncation=false` in JDBC URL.
Such as
```
jdbc:mysql://127.0.0.1:3306/ds?jdbcCompliantTruncation=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