Complementary to what Donna said,

You can issue a
SHOW WARNINGS
sql after some of these queries... the "cutt-off" will be listed there !

You will get a mysql_result in the form:
Level - Code - Message

Warning - 1265 - Data truncated for column 'column_name' at row X.

Gabriel PREDA


On 1/5/07, Olaf Stein <[EMAIL PROTECTED]> wrote:
Hi all

If I insert a value to great for a field (e.g. '123456' into a varchar(5)
field), mysql runs the insert without warning or error and cuts of what
doesn't fit.

How can I tell it to launch an error and abort the insert?

Thanks
Olaf


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]




--
-- -- -- -- -- -- -- -- -- -- -- -- --
Gabriel PREDA
Senior Web Developer

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to