PhotoPost Community - View Single Post

john2k · June 6th, 2006, 03:04 PM

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.

June 6th, 2006, 03:04 PM	#5 (permalink)
john2k Registered User Join Date: Mar 2006 Posts: 6	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.