MySQL/MariaDB SET data type

[woongzeyi]

There is a datatype which is called SET in MySQL and MariaDB. It is similar to ENUM datatype but is used to store a list of enums instead of a single enum.

Difference between ENUM and SET

Defining

• ENUM: permission ENUM('ADMIN', 'MANAGE, 'COMMUNICATE'')
• SET: permission SET('ADMIN', 'MANAGE, 'COMMUNICATE'')

Usage

• ENUM: INSERT INTO roles(permission) VALUE ('ADMIN')
• SET: INSERT INTO roles(permission) VALUE ('ADMIN,MANAGE,COMMUNICATE')
  (Insert comma between each value)

Is there any implementation of it in Exposed? If no, is there anyway to self implement it?