What is wrong with BLOB?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
PanK
Forum Commoner
Posts: 36
Joined: Mon Nov 22, 2004 1:24 pm
Location: Richmond Hill, ON, Canada

What is wrong with BLOB?

Post 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???
Last edited by PanK on Wed Dec 01, 2004 5:00 pm, edited 1 time in total.
rehfeld
Forum Regular
Posts: 741
Joined: Mon Oct 18, 2004 8:14 pm

Post 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
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post 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.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
djot
Forum Contributor
Posts: 313
Joined: Wed Jan 14, 2004 10:21 am
Location: planet earth
Contact:

Post 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
-
Post Reply