Click here to Skip to main content
12,694,842 members (32,716 online)
Click here to Skip to main content
Articles » Database » Database » General » Alternatives
Alternatives
Add your own
alternative version

Tagged as

Stats

12.5K views
3 bookmarked
Posted

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

, 4 Jan 2010 CPOL
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...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

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

Share

About the Author

DavidSchmitt
Founder http://dasz.at/ -- Software for Humans
Austria Austria
No Biography provided

Pro
Pro
| | Privacy | Terms of Use | Mobile
Web01 | 2.8.170118.1 | Last Updated 4 Jan 2010
Article Copyright 2010 by DavidSchmitt
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid