Posted by xclarky on 02/05/06 14:57

ENUM is basically the same as SET however it allows NULL values.
Therefore this would be a wrong data type to use considering what you
are storing.

As you are storing an array, I would advise you to break it town to
text so you basically have a list of numbers, as you have done.

You can then store that list in your field, VARCHAR or TEXT should be
appropriate depending on the length of the list.

When retreiving the data you can use explode() or array_map() to create
an array of the numbers for whatever purpose you wish.

Hope that helps.

[Back to original message]