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