On Fri, 2005-12-02 at 14:30 -0500, Cees Hek wrote: > If you decide to insert a number higher than the > max in that column when using MySQL, it just truncates it to the > maximum allowed value.
As someone else pointed out earlier in the thread, running 5.0 in strict mode would prevent this. It prevents bad dates too. There's a POSTGRESQL mode that mimics the restrictions offered by Pg. http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html - Perrin --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/[email protected]/ http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
