How does the database (mySQL if a particular example is important) determines the size of the column needed to store an ENUM?
Is it something simple like the same byte for less than 256 enum options, etc?
MySQL manual says "1 or 2 bytes, based on the number of calculated values" if in ENUM 256 is less than the expected value, so it uses 1 byte, otherwise 2.
See:
Comments
Post a Comment