On Thu, 22 Feb 2007 17:14:11 -0600
Jim Nasby <decibel@decibel.org> wrote:
> On Feb 20, 2007, at 11:59 PM, Adam Rich wrote:
> > "As of 5.0.2, the server requires that month and day values
> > be legal, and not merely in the range 1 to 12 and 1 to 31,
> > respectively."
>
> Yes, but any session is free to change that setting and insert
> whatever garbage they want. AFAIK there's absolutely no way to
> prevent that. So your data is still very much subject to getting
> trashed.
Even if you activate the strict mode, you cannot be sure, that Mysql
will not result invalid data from the table inserted by another session
not using strict mode.
Kind regards
--
Andreas 'ads' Scherbaum
Failure is not an option. It comes bundled with your Microsoft product.
(Ferenc Mantfeld)