Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Question about MySQL Blobs


Allen Graves

1:11 pm on Jul 16, 2010 (gmt 0)

5+ Year Member

I have an "out of the box" CMS that I use for an article repository.

One of the fields in the database is a TINYBLOB field. It is currently storing the users' bio.

The problem is that it only stores a "tiny" bit of info and conveniently chops off anything after that.

I would like to let the users have more than a couple of lines for their bio!

Can I simply change the database column setting to "BLOB" or will that screw everything up?


p.s. I've already made a backup of the database. :-)


4:23 pm on Jul 16, 2010 (gmt 0)

WebmasterWorld Senior Member rocknbil is a WebmasterWorld Top Contributor of All Time 10+ Year Member

Is the data for the bio all text data?

Seems like changing it to text might be more efficient, if not more efficient, certainly more appropriate. At any rate, bolb and text are the same lengths.

A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types are TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB. These differ only in the maximum length of the values they can hold. The four TEXT types are TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. These correspond to the four BLOB types and have the same maximum lengths and storage requirements.

Manual [dev.mysql.com]

To answer the question, I imagine it wouldn't create any catastrophes, it would just allocate more space in the table. The inverse, of course, wouldn't be true and would truncate data.

Allen Graves

8:32 pm on Jul 16, 2010 (gmt 0)

5+ Year Member

Thanks - yea, it's just text and html (links, lists, etc...).

I'll give it a shot this weekend.

Featured Threads

Hot Threads This Week

Hot Threads This Month