Datatype Reference
- bin.base64 datatype
- MIME-style Base64 encoded binary BLOB.
- bin.hex datatype
- Hexadecimal digits representing octets.
- boolean datatype
- 0 or 1, where 0 == "false" and 1 =="true".
- char datatype
- String, one character long.
- date datatype
- Date in a subset ISO 8601 format, without the time data. For example: "1994-11-05".
- dateTime datatype
- 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 datatype
- 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".
- entity datatype
- Represents the XML ENTITY type.
- entities datatype
- Represents the XML ENTITIES type.
- enumeration datatype
- Represents an enumerated type (supported on attributes only).
- fixed.14.4 datatype
- 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 datatype
- 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.
- id datatype
- Represents the XML ID type.
- idref datatype
- Represents the XML IDREF type.
- idrefs datatype
- Represents the XML IDREFS type.
- int datatype
- Number, with optional sign, no fractions, and no exponent.
- nmtoken datatype
- Represents the XML NMTOKEN type.
- nmtokens datatype
- Represents the XML NMTOKENS type.
- notation datatype
- Represents a NOTATION type.
- number datatype
- 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.)
- string datatype
- Represents a string type.
- time datatype
- Time in a subset ISO 8601 format, with no date and no time zone. For example: "08:15:27".
- time.tz datatype
- Time in a subset ISO 8601 format, with no date but optional time zone. For example: "08:1527-05:00".
- i1 datatype
- Integer represented in one byte. A number, with optional sign, no fractions, no exponent. For example: "1, 127, -128".
- i2 datatype
- Integer represented in one word. A number, with optional sign, no fractions, no exponent. For example: "1, 703, -32768".
- i4 datatype
- Integer represented in four bytes. A number, with optional sign, no fractions, no exponent. For example: "1, 703, -32768, 148343, -1000000000".
- r4 datatype
- 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 datatype
- Unsigned integer. A number, unsigned, no fractions, no exponent. For example: "1, 255".
- ui2 datatype
- Unsigned integer, two bytes. A number, unsigned, no fractions, no exponent. For example: "1, 255, 65535".
- ui4 datatype
- Unsigned integer, four bytes. A number, unsigned, no fractions, no exponent. For example: "1, 703, 3000000000".
- uri datatype
- Universal Resource Identifier (URI). For example, "urn:schemas-microsoft-com:Office9".
- uuid datatype
- Hexadecimal digits representing octets, optional embedded hyphens that are ignored. For example: "333C7BC4-460F-11D0-BC04-0080C7055A83".
This documentation is automatically generated using XSL. Stylesheet available at http://msdn.microsoft.com/xml.