OT: insert a list into MySQL database

Falk's icon
Rob Ramirez's icon

what about trying TINYTEXT data type.

Falk's icon
Rob Ramirez's icon

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

-rob