Appendix D. Microsoft XML Data Types


graphics/chic01.gif

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."



XML and SQL Server 2000
XML and SQL Server 2000
ISBN: 0735711127
EAN: 2147483647
Year: 2005
Pages: 104
Authors: John Griffin

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net