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