The numeric values (the binary code) is decided by the sequence of the values in your SET type colume.
For example, if you define a SET type column like this:sports set('swimming','skatting','running','tennis','football'); Then the numberic values is like this:values binary code numeric valueswimming 00000001 1skatting 00000010 2running 00000100 4tennis 00001000 8football 00010000 16I think this will be very clear, OK?!
For more information on this limit, see Section C.10.5, “Limits Imposed by File Structure”.
Duplicate values in the definition cause a warning, or an error if strict SQL mode is enabled.
On my tries i get simply no valueit would be good if Mysql's staff would include tips on how to insert data in SET colums, wouldn't it?