OT: insert a list into MySQL database

May 13, 2007 at 2:56pm

OT: insert a list into MySQL database

#31890
May 14, 2007 at 3:39am

what about trying TINYTEXT data type.

#104081
May 14, 2007 at 9:13am

#104082
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

#104083
May 16, 2007 at 10:14pm

#104084

You must be logged in to reply to this topic.