[wp-trac] [WordPress Trac] #48377: sql_mode ANSI is incompatible with WP in MySQL 5.7.5+

[WordPress Trac]

#48377: sql_mode ANSI is incompatible with WP in MySQL 5.7.5+
--------------------------+-----------------------------
 Reporter:  jnylen0       |       Owner:  SergeyBiryukov
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  5.4
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:  fixed
 Keywords:                |     Focuses:
--------------------------+-----------------------------

Comment (by kenjigarland):

 For any fellow WP + Digital Ocean managed database users out there who
 come across this ticket in the future, sometime after @jnylen0's comment
 above, Digital Ocean added a "Global SQL Mode" option to the Settings tab
 for managed db servers in their control panel, so now customers **can**
 change the default sql_mode.

 That setting came in handy for my agency, where my coworkers & I ran into
 a few issues with plugins that used custom queries containing double
 quotes. Turned out we still needed to explicitly disable `ANSI_QUOTES`,
 even though `ANSI` had been disabled by core.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/48377#comment:5>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform