Talk:Binary large object

From Wikipedia, the free encyclopedia

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!

[edit] tinyblob

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

[edit] WHAT IS BLOB?

[edit] BLOB

'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.

Syntax

{ 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 (blob comparsions)

select a.name as double_one, b.name as double_two from pictures as a, pictures as b where a.name < b.name and a.pic = b.pic order by 1,2;

59.93.8.69 07:28, 4 February 2007 (UTC)MALU KERALA