Forums > MaxMSP

OT: insert a list into MySQL database

May 13, 2007 | 2:56 pm


May 14, 2007 | 3:39 am

what about trying TINYTEXT data type.


May 14, 2007 | 9:13 am


May 14, 2007 | 9:44 pm

i’ve some mysql experience, but none combining it with max.
it seems if you need to store 128 numbers from 0 to 127, you’re going to need a bigger sql type than varchar 128.

if i’m not mistaken, the list: [1 13 127] will take up 8 chars in an sql database, not 3.

i can take a look at your patch, but make sure you’ve created a field with enough storage space. probably 3*128 + 127 = 511 characters. so you will need TEXT or VARCHAR(512).

http://www.htmlite.com/mysql003.php

-rob


May 16, 2007 | 10:14 pm


Viewing 5 posts - 1 through 5 (of 5 total)