Hi!
How do i fix the error that appear in my system called
"Data truncated for column 'designation' at row 1"

the "designation" field is a drop down menu that enable user to choose designation that they want. here is the code for the table
<select name="designation" size="1">
<option selected="selected" value=''>-Select Designation-</option>
<option value='Dean'>Dean</option>
<option value='Assistant Registrar'>Assistant Registrar</option>
<option value='Program Manager'>Program Manager</option>
<option value='Lecturer'>Lecturer</option>
<option value='Other'>Other</option>
</select>


My system works fine before and i didnt do any changes to it.
Please help me...
Thank you!

some1 must hv change Ur table's column design or da new value is too long

btw U shld design Ur table to store designation as Id rather than full sentence, U can save alot of table space by doin tis

i've changed the table field of 'designation' type from enum to varchar(20) and its work. By the way, changing the table name from designation to id didnt do any changes and still appear the 'data truncated' error to my webpage. I want the type to be 'enum' rather than varchar. Please help me on this...

No I min store Ur designation data like below & change data type to INT, U can save alot of space from CHAR to INT & ofcos da length of data, for Ur future table design la

<option value='1'>Dean</option>
<option value='2'>Assistant Registrar</option>
<option value='3'>Program Manager</option>
<option value='4'>Lecturer</option>