Content Column Type

The collection metadata component that specifies the SQL data type of the column that stores the document content.

Property Value
Default value

  • JSON, if database initialization parameter compatible is at least 20 and component mediaTypeColumn.name is not specified (the content is homoogeneous — JSON data only).

  • BLOB, otherwise.

If the content type is BLOB then the format is native JSON binary (OSON) if the database you use is an Oracle Autonomous Database (Autonomous JSON Database, Autonomous Transaction Processing or Autonomous Data Warehouse); otherwise, it is textual (unparsed Unicode character data.).

If the database you use is an Autonomous JSON Database (AJD) then component mediaTypeColumn.name cannot be specified — the content must be JSON data (homogeneous).

Allowed values

JSON (only if database initialization parameter compatible is at least 20)

VARCHAR2

BLOB

CLOB
JSON collection metadata document path contentColumn.sqlType

Note: You need certain versions of SODA drivers and related software to support collection content type that uses Oracle’s native JSON binary format, OSON, that is, for JSON type or for BLOB type with format OSON. See SODA Drivers

Related Topics