what is BLOB and CLOB large objects

Viewing 1 reply thread
  • Author
    Posts
    • #5310
      DataFlair TeamDataFlair Team
      Spectator

      BLOB and CLOB large objects?

    • #5311
      DataFlair TeamDataFlair Team
      Spectator

      BLOB stands for Binary Large Objects. It is a large object type in DataBase system. BLOB can store a large chunk of data, document types and even media files like audio or video files. BLOB allocates space in Giga Bytes. To write a BLOB value to your database, issue the appropriate INSERT or UPDATE statement and pass the BLOB value as an input parameter.

      CLOB stands for Character Large Objects.It is a datatype used by various data base management systems to store large amounts of character data upto 4GB in size. Common data types used for storing character data include char, varchar, and text. Some database management systems also support additional text data types such as tinytext, mediumtext, and longtext.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.