What is wrong with BLOB?
Moderator: General Moderators
What is wrong with BLOB?
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???
Last edited by PanK on Wed Dec 01, 2004 5:00 pm, edited 1 time in total.
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:
I saw this info on the mysql website a while back, but I can't find it now.
http://www.htmlite.com/mysql003.phphttp://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.
I saw this info on the mysql website a while back, but I can't find it now.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
-
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
-
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
-