When defining a BLOB field, what is the recommended size? 1

[southbeach]

I guess my title covers my entire subject matter

I am, for the first time, using BLOB field. When I use TEXT I normally set it to 10 (think to remember this from MS-SQL). What should I use as length when using BLOB? Does it matter?

Thanks

 

[TonyGroves]

A BLOB-type field can be declared as TINYBLOB, BLOB, MEDIUMBLOB, or LONGBLOB, which give capacities of 255, 64k, 1.6M, and 4.2G bytes respectively. You do not specify a numerical length. Which one you use depends on the maximum possible length of the data the field will hold.

 

[southbeach]

OK - that is very good information - Thanks!