SET SQL_MODE = ''; does not work

Hello,

I have a problem with the configuration of a database.
It is set to SQL_MODE =
'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE _SUBSTITUTION'
and I can not save 'empty' dates.

After searching the manual, I found something about SQL_MODE and
wanted to set it, but it does not work. Not even for the Session.

What I do:

select @@sql_mode;
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_ SUBSTITUTION
SET SQL_MODE = '';
(no result, "Abgabe erzeugte keine Ergebnismenge")
select @@sql_mode; is still the same as before.

I am logged in as root. Any suggestion?

Best regards
Ralph

Does SET @@SQL_MODE = '' work?


--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

On Tue, 15 May 2007 15:02:18 +0200, Willem Bogaerts
<w.bogaerts@kratz.maardanzonderditstuk.nl> wrote:

>Does SET @@SQL_MODE = '' work?

Don't you have to stop and restart MySQL (service) for these types of
changes to take effect?

Lee