[development] DB best pratices, improving portability, MySQL ANSI mode

Ivan Sergio Borgonovo mail at webthatworks.it
Thu Mar 13 10:56:22 UTC 2008


I just came across this:

http://dev.mysql.com/doc/refman/5.0/en/faqs-sql-modes.html
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

setting mode to ANSI should help to debug the code and improve
portability to other DB even if I've heard that the ANSI mode is not
as strict as you'd expect.

I remember a similar proposal for increasing the "strictness" of PHP
setting and verbose error reporting before committing to core.

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it



More information about the development mailing list