Web Analytics Made Easy -
StatCounter Enum or TinyInt - CodingForum

Announcement

Collapse
No announcement yet.

Enum or TinyInt

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Enum or TinyInt

    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

  • #2
    Asked and answered elsewhere.

    Comment

    Working...
    X