| 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". The date itself is not validated (for example, 2-31-99 will pass validation). |
| 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 the same range as the 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 |
Same as "float." 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". |
