Large Objects


Large objects enable storing large amounts of information inside a single field.

  • Data sets can contain large objects
    • e.g., multi-media files, large text documents, or binary data
  • when an image is stored in a database, it will usually be converted to binary and stored as a large object
    • known as Binary Large Object (BLOB) data type
  • when you need to store a large amount of text in a field, use the Character Large Object (CLOB) data type
    • A data type used to store large amounts of character (text) data, specifically large bodies of text that exceed the storage capacity of standard text fields
    • can hold large amounts of text in multiple formats:
      • plain text
      • XML
      • JSON
      • HTML