Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

(click on this box to dismiss)

BLOB and CLOB Data Types

What is the difference between BLOB and CLOB data types in Cubrid and how do we make use of these? (In some user scenarios?)

link comment (0) accepted answer
asked 4 years ago
15 Answers

BLOB and CLOB stand for Binary large object and Character large object respectively. Values of table columns declared using these types are stored independently of the table records. The size limit is determined by the external storage.

Suppose you want to allow the users to upload pictures to your web site. You will probably want to yous a BLOB column for storing those pictures.

Suppose you are writing a content management system and want to store product descriptions in your database. You don't want to impose max length limitations on the product description. So you will probably want to store these in a CLOB column.

link comment (0)
answered 3 years ago

You are either using a very old browser or a browser that is not supported.
In order to browse you need to have one of the following browsers:

Internet Explorer: Mozilla Firefox: Google Chrome: