On Thu, 22 Feb 2007 17:14:11 -0600 Jim Nasby <decibel@xxxxxxxxxxx> 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)
