Page 1 of 1

What is wrong with BLOB?

Posted: Wed Dec 01, 2004 4:14 pm
by PanK
I just finnish writing script that uses BLOB.I'm using it fore storing images, and thumbnails. It seems ok, but I heard that BLOB is not good to use, can please somebody tell me why???

Posted: Wed Dec 01, 2004 4:32 pm
by rehfeld
why did this person say it was not "good" to use ? what is it being used for?

"good" is meaningless w/out context

Posted: Wed Dec 01, 2004 5:51 pm
by pickle
This person might be referring to the fact that the BLOB can only hold a certain amount of data, while MEDIUMBLOB and LONGBLOB can hold quite a bit more:
http://www.htmlite.com/mysql003.php wrote:TEXT A string with a maximum length of 65535 characters.
BLOB A string with a maximum length of 65535 characters.
MEDIUMTEXT A string with a maximum length of 16777215 characters.
MEDIUMBLOB A string with a maximum length of 16777215 characters.
LONGTEXT A string with a maximum length of 4294967295 characters.
LONGBLOB A string with a maximum length of 4294967295 characters.
http://www.htmlite.com/mysql003.php

I saw this info on the mysql website a while back, but I can't find it now.

Posted: Wed Dec 01, 2004 7:13 pm
by djot
-
Information about columns/fields may be found here:
http://dev.mysql.com/doc/mysql/en/Column_types.html

"blob" is described here:
http://dev.mysql.com/doc/mysql/en/Strin ... rview.html

djot
-