I did searched for the equivalent and came across the suggested page, it says there is no direct equivalent for the set data type. Hence here i requested atleast for a work around if not the equivalent.
The SET datatype allows more than one value to the column as you ve posted in your reply. i ve not come across such a feature in any other data base and whats wrong in claiming it as a special data type ..
Then again, one could remember what "normalisation" means and create another table to hold the many values associated with the row
SET is evil, and should never be used in the first place (then you wouldn't have these conversion problems to other databases)
the solution, as tony suggests, is to define a many-to-many table which will hold the (possibly multiple) pairs of foreign keys, one key referring back to this data table, and the other key referring to a third "values" table which lists the allowable values (the same values declared in the SET)