Q

Blob field equivalents in MySQL

Blob field equivalents in MySQL

What is the equivalent of a blob field in MySQL?

MySQL offers four blob types, which differ only in maximum size. They are tinyblob (256 bytes), blob (64 kilobytes),

mediumblob (16 megabytes) and longblob (4 gigabytes). There are also the binary and varbinary data types, which are the same as char ard varchar, but store binary strings. See http://dev.mysql.com/doc/refman/5.0/en/blob.html and http://dev.mysql.com/doc/refman/5.0/en/binary-varbinary.html for more details.

This was first published in January 2007

Dig deeper on Open source databases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close