Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


0
(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 3 years ago
picador_jr
292
15 Answers
1

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 2 years ago
swanotets
263
tagged




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



Internet Explorer: Mozilla Firefox: Google Chrome: