Talk:Binary large object

From Wikipedia, the free encyclopedia
Jump to: navigation, search
WikiProject Computing (Rated Start-class, Mid-importance)
WikiProject icon This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
Start-Class article Start  This article has been rated as Start-Class on the project's quality scale.
 Mid  This article has been rated as Mid-importance on the project's importance scale.

What is Oracle's defination of this terminology? BTW, what does Wikipedia do about different established authors naming different things by different names! In school, I read about Normal Groups, which meant slightly different things to different audiences. In CS parlence, this is called an overloaded expression, whose meaning is clear only by context!


what's a tinyblob datatype? --Abdull 8 July 2005 19:09 (UTC)


'Short for binary large object, a collection of binary data stored as a single entity in DBMS. BLOBs are used primarily to hold multimedia objects such as images, videos, and sound, though they can also be used to store programs or even fragments of code. Not all DBMSs support BLOBs.'

A BLOB (binary large object) is a varying-length binary string that can be up to 2,147,483,647 characters long. Like other binary types, BLOB strings are not associated with a code page. In addition, BLOB strings do not hold character data.

The length is given in bytes for BLOB unless one of the suffixes K, M, or G is given, relating to the multiples of 1024, 1024*1024, 1024*1024*1024 respectively.

Note: Length is specified in bytes for BLOB.


{ BLOB | BINARY LARGE OBJECT } [ ( length [{K |M |G }] ) ]

Default A BLOB without a specified length is defaulted to two gigabytes (2,147,483,647).

Corresponding compile-time Java type java.sql.Blob

JDBC metadata type (java.sql.Types) BLOB

Use the getBlob method on the java.sql.ResultSet to retrieve a BLOB handle to the underlying data.

Related information

create table pictures(name varchar(32) not null primary key, pic blob(16M));

--find all logotype pictures

select length(pic), name from pictures where name like '%logo%';

--find all image doubles

select as double_one, as double_two from pictures as a, pictures as b where < and a.pic = b.pic order by 1,2; 07:28, 4 February 2007 (UTC)MALU KERALA


hi please move this article to Binary large object, same Character large object or inverse! thanks

moved, ] (talk) 10:54, 1 December 2010 (UTC)

Database only?[edit]

Are you sure this refers only to data stored in databases? For instance, people refer to proprietary, binary data in the Linux kernel as blobs as well, and a version control system (or a codebase) is hardly a database. I think the more general idea behind the term is having large chunks of binary data in a place where you normally have structured data. Agree/disagree? -- (talk) 18:36, 29 May 2015 (UTC)

External links modified[edit]

Hello fellow Wikipedians,

I have just added archive links to one external link on Binary large object. Please take a moment to review my edit. You may add {{cbignore}} after the link to keep me from modifying it, if I keep adding bad data, but formatting bugs should be reported instead. Alternatively, you can add {{nobots|deny=InternetArchiveBot}} to keep me off the page altogether, but should be used as a last resort. I made the following changes:

When you have finished reviewing my changes, please set the checked parameter below to true or failed to let others know (documentation at {{Sourcecheck}}).

You may set the |checked=, on this template, to true or failed to let other editors know you reviewed the change. If you find any errors, please use the tools below to fix them or call an editor by setting |needhelp= to your help request.

  • If you have discovered URLs which were erroneously considered dead by the bot, you can report them with this tool.
  • If you found an error with any archives or the URLs themselves, you can fix them with this tool.

If you are unable to use these tools, you may set |needhelp=<your help request> on this template to request help from an experienced user. Please include details about your problem, to help other editors.

Cheers.—cyberbot IITalk to my owner:Online 14:45, 29 March 2016 (UTC)