bin.base64 | MIME-style Base64 encoded binary BLOB. |
bin.hex | Hexadecimal digits representing octets. |
boolean | 0 or 1, where 0 == "false" and 1 =="true". |
char | String, one character long. |
date | Date in a subset ISO 8601 format, without the time data. For example:
"1994-11-05". |
dateTime | Date in a subset of ISO 8601 format, with optional time and no optional
zone. Fractional seconds can be as precise as nanoseconds. For example:
"1988-04-07T18:39:09". |
dateTime.tz | Date in a subset ISO 8601 format, with optional time and optional zone.
Fractional seconds can be as precise as nanoseconds. For example:
"1988-04-07T18:39:09-08:00". |
fixed.14.4 | Same as "number" but no more than 14 digits to the left of the
decimal point, and no more than 4 to the right. |
float | Real number, with no limit on digits; can potentially have a leading
sign, fractional digits, and optionally an exponent. Punctuation as in
U.S. English. Values range from 1.7976931348623157E+308 to
2.2250738585072014E-308. |
int | Number, with optional sign, no fractions, and no exponent. |
number | Number, with no limit on digits; can potentially have a leading sign,
fractional digits, and optionally an exponent. Punctuation as in U.S.
English. (Values have same range as most significant number, R8,
1.7976931348623157E+308 to 2.2250738585072014E-308.) |
time | Time in a subset ISO 8601 format, with no date and no time zone. For
example: "08:15:27". |
time.tz | Time in a subset ISO 8601 format, with no date but optional time zone.
For example: "08:1527-05:00". |
i1 | Integer represented in one byte. A number, with optional sign, no
fractions, no exponent. For example: "1, 127, -128". |
i2 | Integer represented in one word. A number, with optional sign, no
fractions, no exponent. For example: "1, 703, -32768". |
i4 | Integer represented in four bytes. A number, with optional sign, no
fractions, no exponent. For example: "1, 703, -32768, 148343,
-1000000000". |
i8 | Integer represented in eight bytes. A number with optional sign, no fractions, no exponent, and 19-digit precision. Range is from
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. |
r4 | Real number, with seven digit precision; can potentially have a leading
sign, fractional digits, and optionally an exponent. Punctuation as in
U.S. English. Values range from 3.40282347E+38F to 1.17549435E-38F. |
r8 | Real number, with 15 digit precision; can potentially have a leading
sign, fractional digits, and optionally an exponent. Punctuation as in
U.S. English. Values range from 1.7976931348623157E+308 to
2.2250738585072014E-308. |
ui1 | Unsigned integer. A number, unsigned, no fractions, no exponent. For
example: "1, 255". |
ui2 | Unsigned integer, two bytes. A number, unsigned, no fractions, no
exponent. For example: "1, 255, 65535". |
ui4 | Unsigned integer, four bytes. A number, unsigned, no fractions, no
exponent. For example: "1, 703, 3000000000". |
ui8 | Unsigned integer, eight bytes. A number, unsigned, no fractions, no exponent. Range is 0 to 18,446,744,073,709,551,615. |
uri | Universal Resource Identifier (URI). For example:
"urn:schemas-microsoft-com:Office9". |
uuid | Hexadecimal digits representing octets, optional embedded hyphens that
are ignored. For example:
"333C7BC4-460F-11D0-BC04-0080C7055A83". |