On Fri, 16 Apr 2004, Christopher Kings-Lynne wrote:
> > I always ran one of the 2 scripts (can't remember which one) and after that
> > started checking the dump file, because there were things that didn't get
> > changed correctly[1].
> >
> > [1]: I always remember the first conversion I did. I found out that MySQL
> > accepted dates like 30/2/2000 or 0-0-0000.
> > Very odd.
>
> Yes, MySQL has always accepted those as perfectly valid dates. It's
> quite broken.
the sad thing is that while MySQL implemented a -ansi switch that
supposedly turns on ansi compliance, it only fixes about 1/2 of all the
non-compliance issues. Yet another half-implemented feature... :)