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