Just to make sure I am understanding this correctly, the STRICT MODE forces the database server to only use MySQL50 functionality?
Also, disabling the strict mode and setting backward compatibility to 4.0 - does this allow the database server to operate in MySQL5.0 mode by default but still allow MySQL4.0 compatibility? Would it be 4.0 functionality by default? Would 5.0 functionality be completely removed?
Trying to determine how other scripts and databases will be affected by changing these settings.
Thanks for your help and quick reply.