Erik Darling shows why you might not want to set ANSI_DEFAULTS ON:
Rather than just setting the required options, which was apparently a lot of typing, someone had just set all the ANSI defaults on.
Read on to learn what the problem is and an alternative to using ANSI_DEFAULTS.