The "storageEncoding" property in the variant object may optionally specify a more specific storage format. For most variant types it is omitted.
Basic Types
"type" |
"storageEncoding" |
Description |
|---|---|---|
"binary" |
The value is stored as raw bytes. | |
"string" |
The value is stored as a UTF-8 string. | |
"boolean" |
The value is stored as a byte containing 0 (false) or 1 (true). |
|
"json" |
The value is stored in its exact JSON form as UTF-8 characters. For example, a JSON string, such as "my string", is stored as UTF-8 characters including the double quotes . A number is stored as UTF-8 digits, such as -123.45. true, false, and null are stored as UTF-8 characters. A JSON object, such as {"key": "value"} is stored as UTF-8 characters including all punctuation. |
|
"number" |
The value is stored as UTF-8 digits such as -123.45. |
|
"number" |
["tinyint"] |
The value is stored as a 1-byte signed integer. |
"number" |
["smallint"] |
The value is stored as a 2-byte signed integer. |
"number" |
["integer"] |
The value is stored as a 4-byte signed integer. |
"number" |
["bigint"] |
The value is stored as a 8-byte signed integer. |
"number" |
["float"] |
The value is stored as a 4-byte IEEE floating point. |
"number" |
["double"] |
The value is stored as an 8-byte IEEE floating point. |
"number" |
["numeric"] |
The value is stored as a 32-didgit fixed-point number. |
Text Formats
"type" |
"storageEncoding" |
Description |
|---|---|---|
"css" |
The value is stored as unvalidated cascading style sheet code, which is used to style web pages. | |
"csv" |
The value is stored as unvalidated comma-separated value data, which is useful for importing to and from spreadsheets and databases. | |
"html" |
The value is stored as unvalidated Hypertext Markup Language code, which is used to create web pages. | |
"javascript" |
The value is stored as unvalidated JavaScript code, which is a commonly used programming language. | |
"markdown" |
The value is stored as unvalidated Markdown code, which is used to represent published documents. | |
"rtf" |
The value is stored as unvalidated Rich-text Format, which is a legacy binary format used to represent published documents. | |
"sql" |
The value is stored as unvalidated Structured Query Language code, which is used to query databases. | |
"tsf" |
The value is stored as unvalidated Time Series Forecasting Format, which is used to represent time-based, analytic data. | |
"turtle" |
The value is stored as unvalidated Turtle data, which is used to represent semantic graph data. | |
"vcard" |
The value is stored as unvalidated vcard data, which is used to represent business cards. | |
"xml" |
The value is stored as unvalidated eXtensible Markup Language code, which is used to represent published documents. |
Binary Formats
"type" |
"storageEncoding" |
Description |
|---|---|---|
"mp4" |
The value is stored as unvalidated MP4 video or audio data. | |
"quicktime" |
The value is stored as unvalidated Quicktime movie. | |
"bmp" |
The value is stored as unvalidated bitmap image. | |
"gif" |
The value is stored as unvalidated GIF image. | |
"jpeg" |
The value is stored as unvalidated JPG image. | |
"svg" |
The value is stored as unvalidated scalable vector graphic image, which is a highly compact image format. | |
"mp4" |
The value is stored as unvalidated MP4 video or audio data. | |
"png" |
The value is stored as unvalidated PNG image. | |
"flac" |
The value is stored as unvalidated FLAC high-fidelity audio. | |
"mpeg" |
The value is stored as unvalidated MPEG video. | |
"opus" |
The value is stored as unvalidated OPUS audio. | |
"midi" |
The value is stored as unvalidated Musical Instrument Digital Interface data, which is used to play electronic instruments, represent sheet music, and represent musical performances. | |
"spMidi" |
The value is stored as unvalidated Scalable Polyphony MIDI data. | |
"otf" |
The value is stored as unvalidated OpenType Font data, which is useful for storing a font in the database. |