Open Source RDBMS - Seamless, Scalable, Stable and Free

English | 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?)

링크 댓글 쓰기 (0) 선택된 답변
질문시간 3년 전
picador_jr
292
15 답변들
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.

링크 댓글 쓰기 (0)
답변시간 2년 전
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: