|
|
May 13, 2007 at 2:56pm
OT: insert a list into MySQL database
|
|
|
May 14, 2007 at 3:39am
what about trying TINYTEXT data type.
|
|
|
May 14, 2007 at 9:44pm
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
|
