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

Last Reviewed: February 15, 1999