Hey guys,
we have currently an issue on a software which is connected against DO managed databases (MySQL).
We campe up to the result, that the issue is in the command quotes.

As an example, is NOT working:
SELECT * FROM someting_config where language_id = “2”

IS working
SELECT * FROM someting_config where language_id = 2
(see the “ in the id part.)

Before we are switching to managed database on DO we run this services on a own MySQL instance on a single server on DO. So looks like the managed database cluster can’t handle this.

Is there a way to change this setting? Can’t find anything regarding to it but maybe in the SQL Modes. Currently active:

  • ANSI_QUOTES
  • ERRORFORDIVISIONBYZERO
  • IGNORE_SPACE
  • NOENGINESUBSTITUTION
  • NOZERODATE
  • NOZEROIN_DATE
  • ONLYFULLGROUP_BY
  • PIPESASCONCAT
  • REALASFLOAT
  • STRICTALLTABLES

Thanks a lot!
Best,
Michael

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.

×
Submit an Answer
2 answers

Does no one have any ideas?

Show answer This answer has been marked as resolved by goetzm.