SQL requests with double-quotes not working with managed database
I have a php app that successfully makes SQL requests against MySQL servers. Nevertheless the same app breaks against DO managed database whenever the requests include double-quotes.
The following request returns an error 1054 with managed database while it works with classic MySQL servers.
select * from users where username="demo" => error 1054 select * from users where username='demo' => ok
Is there a way to configure DO managed database to accept double-quotes?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.