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... :) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
