[google-cloud-sql-discuss] How to set innodb_strict_mode = OFF globally in Cloud SQL

Hi, folks!

I'm moving a MySQL DB from on-premise to Cloud SQL and the developer are facing a problem related to NULL values in NOT NULL columns.

Previously, they are able to INSERT a new record without set a value in a NOT NULL column due to innodb_strict_mode parameter which are set to OFF in on-premise today. After moving to Cloud SQL they are not able to use this feature, once the innodb_strict_mode are ON.

An alternative will be set this value in application level, perhaps I want to keep this setting in DB level. Trying to use SET GLOBAL innodb_strict_mode = OFF didn't work for me.

Thanks! 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/5cad2874-735a-495e-ab89-5729155c2e67%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.