OT: insert a list into MySQL database

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:13am

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).



May 16, 2007 at 10:14pm


You must be logged in to reply to this topic.