Recognition

No awards yet.

Posts

1 Posts
  • Published Question

    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 e...
    Accepted Answer: This is related to the sql_mode used. There's a sqlmode setting, 'ANSIQUOTES' that will make the " an identifier character. e.g. ``` mysql> set session sqlmode = 'ONLYFULLGROUPBY,STRICTTRANSTABLES,NOZEROINDATE,NOZERO...
    1 By shonore MySQL