Enum or TinyInt

[phantom007]

Hi

When you create a user table with a column indicating whether the user is active or inactive or perhaps a payment table with the various payment status viz. "Payment received", "Payment pending", "payment cancelled"

what datatype do you prefer for the status column, do you keep it ENUM so that you can store the status as strings or do you keep the datatype as tinyint/int and store numbers representing each number as a status?


Thanks

[guelphdad]

Asked and answered elsewhere.