
13-01-2008, 05:52 PM
|
 |
New kid on the block
|
|
Join Date: Jan 2008
Location: Kuala Lumpur
Posts: 5
Rep Power: 0
|
|
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!
|