View Single Post
  #1 (permalink)  
Old 13-01-2008, 05:52 PM
silentD's Avatar
silentD silentD is offline
New kid on the block
 
Join Date: Jan 2008
Location: Kuala Lumpur
Posts: 5
Rep Power: 0
silentD is on a distinguished road
Unhappy How do i fix data truncated error in mysql?

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!
Reply With Quote