PRB: Error Msg 1007: The Number '<Many-digit Number>' Is Out of Range

ID: Q203787

The information in this article applies to:

Microsoft SQL Server versions 6.5, 7.0

SYMPTOMS

The following error occurs when inserting a positive or negative numeric (decimal) or float number with a precision (digits in the number) greater than 28 digits:

Error -Update SpcStat PutDB (4 1007)
[Microsoft][ODBC SQL Server Driver][SQL Server]The number
'-3402823466385289000000000000000000000.0000000000'
is out of range for numeric representation (max precision: 28).

NOTE: The actual value shown in the error message will be the number that is being manipulated in the statement.

CAUSE

This behavior is by design. The default processing for a user input decimal (from the parser) is now numeric, which supports a maximum precision of 28.

WORKAROUND

If you want to input data with higher precision, do either of the following:

Use the exponential notation (such as 10.0E-32, 10.0e-32, 10.0E32, or 10.0e32).

-or-

Use trace flag 107 to bypass the numeric processing that causes the error message.

Additional query words: scientific notation

Keywords :
Version : winnt:6.5,7.0
Platform : winnt
Issue type : kbprb