FieldType "Array" ?

[xces]

Heya,

I need to know if MySQL supports the field type Array, so if i have a field with the name "test" i want the field "test" to be an array of 50 items... is this possible?

[jeremuck]

not really.
SET is the closest thing, however if you want an array to be stored, why not just serialize it or explode it or something?

[xces]

Ok, lets say you have 6 values you want to store into 1 field:

integers:
0|1|0|0|1|1

strings:
test|some|array|function|read|me

date:
(LONG)|(LONG)|(LONG)|(LONG)|(LONG)|(LONG)
etc etc..

So this means you have to write a read/write function for every datatype you have?

Why isn't this standard in MySQL? Is it supported in Oracle or some other db ??

[jeremuck]

no, exploding is a simple function call, imploding is just as simple to get it back.
serialize/ unserialize is also a simple function call.

you don't need read / write functions.

look at the manual if you are unfamiliar

[man]serialize[/man]