3 ms·

Possibly because ENUM column types don't seem to exist in all SQL databases? I could be wrong though...

• craftyguy 8y ago
  ENUM is in mysql/mariadb. Not sure about oracle or some of the more obscure ones..
  • nerdponx 8y ago
    Postgres has it: https://www.postgresql.org/docs/current/static/datatype-enum.html https://www.postgresql.org/docs/current/static/datatype-enum...
    • craftyguy 8y ago
      Yea I assumed Postgres was covered by OP's suggestion to use ENUM.
    • entee 8y ago
      Just poking around in docs, seems first added in 8.3?
• emmelaich 8y ago
  You can just make an other table and map a few integers to the statuses. It's another join but I wouldn't think so much difference over the 'lookup' required for proper ENUM support?