帮个忙，一个mysql的blob的长度问题。

[charbee]

我用来放图片，　但是超过64k的就放不下。
大家教教我怎么办。

[lxf_1976]

那试试MEDIUMBLOB或者LONGBLOB字段类型啊

[sandyde2]

ya.. Look at the size limitations for the different
types in the mysql manual. You may want to use a
mediumblob since a blob is limited to 64K.

http://www.mysql.com/doc/en/Storage_requirements.html

CHAR(M)
M bytes, 1 <= M <= 255


VARCHAR(M)
L+1 bytes, where L <= M and 1 <= M <= 255


TINYBLOB, TINYTEXT
L+1 bytes, where L < 2^8


BLOB, TEXT
L+2 bytes, where L < 2^16


MEDIUMBLOB, MEDIUMTEXT
L+3 bytes, where L < 2^24


LONGBLOB, LONGTEXT
L+4 bytes, where L < 2^32

[软猫克鲁]

学习中……

[ezhou]

sandyde2(sandy)讲的真全，学习！

[lonelydreamsym]

受益中 ：)