Hi,
I guess no one will like my suggustion, but here it goes: Use Firebird (http://www.firebirdsql.org), it does support arrays, but to use them you need to write things like stored-procedures or UDF (an extention).
Hello folks!
I have a problem with SQL for MySQL (and pre4sumably any other kind):
Can anone offer a RTFM do do something like this:
create table foo ( boo int, bar varchar; baz array[0..9] of int, # illegal, but needed! ... );
I'm not really thrilled about stuffing all the data into a blob or a varchar and using c/c++/whatever text handling.
Thanks,
Daniel
Ido
First thanks for the replies.
Next, each record consists of some constant stuff (key if you like) followed by a list of integers, say the results of a set of measurements. My current "test" setup produces comma delimited text transaction files - which of course are not very write-sharable and most unsuitable in a web server backend.
I'd like to stick with MySQL/PHP/perl etc.
My conclusion from the answers received is indeed to produce a text string of the form <count>:n1,n2,ne, ...n<count> and use the ususal C/C++/Perl/whatever text goodies to pack and unpack. Aother neat dirty trick might be to tale advantage of the fact that my integers are small (<100) and pack each number into two bytes like we used to do in the bad old days of limited memory and disk space ...
Shabbat shalom,
Daniel
================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
