MS SQL Server - SQL2K5 XQuery data types

Author

SQL2K5 XQuery data types

Mike C#

2006-12-04, 7:12 pm

Hi all,

Re-posting this question from sqlserver.xml newsgroup, since no one there
seems to have an answer. Basically I'm trying to determine the value space
of the xs:float XQuery data type in SQL Server. It seems to be different
from both the SQL REAL data type and the W3C XQuery standard, but I'm not
sure. I've come up with this: 3.4E+38 to -1.401298E-45, 0, +1.401298E-45 to
+3.4E+38. Can anyone confirm this (or if not, give me the correct range?)

Thanks

Erland Sommarskog

2006-12-04, 7:12 pm

Mike C# (xyz@xyz.com) writes:
> Re-posting this question from sqlserver.xml newsgroup, since no one
> there seems to have an answer. Basically I'm trying to determine the
> value space of the xs:float XQuery data type in SQL Server. It seems to
> be different from both the SQL REAL data type and the W3C XQuery
> standard, but I'm not sure. I've come up with this: 3.4E+38 to
> -1.401298E-45, 0, +1.401298E-45 to +3.4E+38. Can anyone confirm this (or
> if not, give me the correct range?)

I passed this on to our internal MVP forum, since this appears to be a
difficult question. (And the hour is too late for me to do any resarch
right now.)

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Mike C#

2006-12-05, 12:12 am

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns989044362143
Yazorman@127.0.0.1...
>
> I passed this on to our internal MVP forum, since this appears to be a
> difficult question. (And the hour is too late for me to do any resarch
> right now.)

Thanks Erland, appreciate it. I did some initial research, and one entry in
BOL compares the XQuery xs:float to the SQL REAL type, but the range just
doesn't appear to be the same, and it also looks like it's not adhering to
the W3C spec here either. Anything you find out would be appreciated.
Thanks.

Mike C#

2006-12-06, 12:12 am

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns989044362143
Yazorman@127.0.0.1...
> Mike C# (xyz@xyz.com) writes:
>
> I passed this on to our internal MVP forum, since this appears to be a
> difficult question. (And the hour is too late for me to do any resarch
> right now.)

I got a response from Brandon Berg over on his blog. It looks like the
range I came up with is correct, and only slightly off from the W3C spec.
The thing that was really puzzling though is the difference between the
xs:float range and the documented SQL REAL data type range. There appears to
be a pretty significant difference in the ranges right around 0 (of course
most people probably wouldn't consider a difference in the 38th - 45th
positions after the decimal point significant).

Thanks

Erland Sommarskog

2006-12-06, 7:12 pm

Mike C# (xyz@xyz.com) writes:
> I got a response from Brandon Berg over on his blog. It looks like the
> range I came up with is correct, and only slightly off from the W3C
> spec. The thing that was really puzzling though is the difference
> between the xs:float range and the documented SQL REAL data type range.
> There appears to be a pretty significant difference in the ranges right
> around 0 (of course most people probably wouldn't consider a difference
> in the 38th - 45th positions after the decimal point significant).

Great to hear that you got it sorted out. My question has not yielded
any response this far.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Sponsored Links