#1265 - Data truncated for column, what does this mean ?

mindwarpltd used Ask the Experts™
I'm getting this error...

#1265 - Data truncated for column

The query is trying to insert '' into the table.

I thought truncated meant too long.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
what is the data type for the column? If it is a smallint or other number field, you may be inserting a string into a number column. Try inserting 0 or NULL instead.


Its a enum, but the field does accept null

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial