Data | Type Description | bin.base64 | MIME-style Base64 encoded binary BLOB | bin.hex | Hexadecimal digits representing octets | boolean | 0 (false) or 1 (true) | char | One character length long string | 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 time 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 time 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 is limited to 14 digits to the left and four to the right of the decimal point. | float | Real number with no limit on digits. Float can 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 | A number with optional sign, no fractions, and no exponent. | number | A number with no limit on digits. It can have a leading sign, fractional digits, and, optionally, an exponent. Punctuation is as in U.S. English. (Values have the same range as R8, 1.7976931348623157E+308 to 2.2250738585072014E-308.) | time | Time in a subset of the ISO 8601 format, with no date and no time zone, for example, "08:15:27." | time.tz | Time in a subset of the ISO 8601 format, with no date, but an optional time zone, for example,"08:1527-05:00." | i1 | A one byte integer with an optional sign, no fractions and no exponent, for example, "1 or 127 or -128." | i2 | A one-word (two byte) integer with an optional sign, no fractions and no exponent, for example, "1 or 669 or -32768." | i4 | A four-byte integer with an optional sign, no fractions and no exponent, for example, "1 or 669 or 32768 or 148343 or -1000000000." | i8 | An eight-byte integer with an optional sign, no fractions, no exponent, and 19-digit precision. It ranges from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. | r4 | A real number with seven-digit precision. It can 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 | This is the same as a float.A real number with 15-digit precision, which can 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 | A one-byte unsigned integer with no fractions and no exponent, for example, "1 or 255." | ui2 | A two-byte unsigned integer with no fractions and no exponent, for example, "1 or 255 or 65535." | ui4 | A four-byte unsigned integer with no fractions and no exponent, for example, "1 or 669 or 3000000000." | ui8 | An eight-byte unsigned integer with no fractions and no exponent. Its range is 0 to 18,446,744,073,709,551,615. | uri | Universal Resource Identifier (URI), for example, " urn:schemas-microsoft-com:Excel4 ." | uuid | Hexadecimal digits representing octets, optional embedded hyphens that are ignored, for example, "132C7AB4-570E-11D0-FF04-1980E7055F83." | |