MSSQL doesn’t (completely) support IEEE754 floating points (NaNs and infinity)

DavidSchmitt

Rate me:

4.33/5 (2 votes)

4 Jan 2010CPOL1 min read

21.8K

After looking for quite a while (it is unbelievable, no?) I have to accept that Microsoft’s SQL Server 2000, 2005 and 2008 do not fully support IEEE-754 floating point numbers. Specifically NaN (Not-a-Number) and +/- Infinity are not allowed. While the 2000 Server seemingly allows such values to...

No downloads associated with this content

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

DavidSchmitt

Founder http://dasz.at/ -- Software for Humans

Austria

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

MSSQL doesn’t (completely) support IEEE754 floating points (NaNs and infinity)

License

Comments and Discussions