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?)
![[Level:5]](http://www.cubrid.org/modules/point/icons/default/5.gif "Rank: 5/30, reputation score 292 (92% completed for the next level)"){kind=icon}
picador_jrBLOB 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.
