|
Home > Archive > MS SQL XML > December 2006 > SQL 2K5 XQuery xs:float range
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 2K5 XQuery xs:float range
|
|
| Mike C# 2006-12-03, 5:15 am |
| Hi all,
Quick question. I'm testing SQL 2005 XQuery and I'm trying to test the
xs:float values against the W3C standard. It looks like the SQL xs:float has
less precision than the standard specifies. Am I correct in determining the
range to be:
-3.4E+38 to -1.401298E-24, and +1.401298E-45 to +3.4E+38
Thanks
| |
| Mike C# 2006-12-03, 5:15 am |
| Oops. That should be:
-3.4E+38 to -1.401298E-45,
and
+1.401298E-45 to +3.4E+38
P.S. - I know BOL says the xs:float type is supposed to match the format of
the SQL REAL data type; however, the range for SQL REALs is:
- 3.40E+38 to -1.18E-38, and 1.18E-38 to 3.40E+38
The apparent range for xs:float appears to be significantly larger than SQL
REAL. I just want to make sure I have the range right. Thanks.
"Mike C#" <xyz@xyz.com> wrote in message
news:Gbwch.269$Bs.11@newsfe11.lga...
> Hi all,
>
> Quick question. I'm testing SQL 2005 XQuery and I'm trying to test the
> xs:float values against the W3C standard. It looks like the SQL xs:float
> has less precision than the standard specifies. Am I correct in
> determining the range to be:
>
> -3.4E+38 to -1.401298E-24, and +1.401298E-45 to +3.4E+38
>
> Thanks
>
|
|
|
|
|