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.9K

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

Views

Daily Counts

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)

Views

License

Comments and Discussions