Re: data truncated for column XX at row 1
It has to do with your SQL mode (value of the 'sql_mode' variable). See
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html for more information. In a strict mode, that insert will cause an error and the insert will fail. In a non-strict mode, the insert will succeed, but you will still get that warning.
-Dave
Subject
Written By
Posted
December 28, 2006 01:02AM
Re: data truncated for column XX at row 1
December 28, 2006 07:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.