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