MySQL Type for multiple values

[Master_Zen]

I need to know if there's a mySQL Type which allows for multiple values which are NOT pre-set.

Here's what I need: I have a mySQL column set at CHAR(2). However, I need each entry in that row to be able to have various values. These contain values similar to country domains (ex: "de", "uk", "fr", "jp", "ru"). I would like to know if there's a way I can have various of those values in one same entry (ex: "de, uk" for one entry).

I noticed the SET type but from what I've read you have to specify each possible value when you create the column which is somewhat tedious. Is there something similar to SET without having to specify values?

[yahyac]

If I understand you correctly, you are looking for multi-valued attributes.

You have a mysql table with several attributes (columns). Each attribute holds one piece of information. However, for this one particular attribute (column), you are wanting it to store more than one item for that particular row of data. Is this what you are wanting to do?

If so, you need to read on multi-valued attributes in sql or mysql. Very easy to do.

[bike5]

varchar?

Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions. (The maximum effective length of a VARCHAR in MySQL 5.0.3 and later is determined by the maximum row size and the character set used. The maximum length overall is 65,532 bytes.)

[Master_Zen]

I will look into multi-valued attributes, that is precisely what I'm looking for.

Thanks!