[Phpmyadmin-devel] MySQL 5 strict

Marc Delisle Marc.Delisle at cegepsherbrooke.qc.ca
Tue Nov 1 07:26:54 CET 2005

Alexander M. Turek a écrit :
> Hash: SHA1
> Hi,
> Sebastian Mendel schrieb:
>>please can anybody heavily test with MySQL 5 in strict mode, as there
>>are many errors with current PMA!
> PMA should be able to witch the SQL mode for its session. Why don't we
> run PMA that way instead? Making PMA compatible to MySQL 5's strict mode
> could be painful and could take a bit more time.
> Regards,

Starting with MySQL 4.1, we can switch the mode. In fact, we are already 
doing it in libraries/export/sql.php. But what if the user or sysadmin 
really wants to check the behavior in ANSI mode? Forcing the mode to 
non-script would block users to verify this behavior.

We could even offer in a future version, a "mode switcher" for users!


More information about the Developers mailing list