I’m using java bean, servlet JSP and mysql for my project. I need to know what data type to use for drop down list and radio button in mysql.
For radio button I only have 2 options so I planned to use boolean. For Drop down list I tried using enum (I initialised in mysql database and it says some error). I used enum because i did some research and a lot resources said use enum.
I’ve attached the picture that shows error message.
Create a separate table for the dropdown list with id and the visible value. The ID can be numeric (tinyint/int).