What is the difference between BLOB and CLOB data types in Cubrid and how do we make use of these? (In some user scenarios?)
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.
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: