Article ID: 141664 - Last Review: March 2, 2005 - Revision: 3.3

BUG: Convert From Binary to Numeric Gives Error 8114

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q141664
BUG#: 12244 (SQLBUG_60)
BUG#: 19019 (SQLBUG_65)
BUG#: 57913 (SQLBUG_70)
Expand all | Collapse all

SYMPTOMS

The SQL Server 6.0 "Transact-SQL Reference" manual states, on page 189, that binary can be explicitly converted to numeric, however, using the Convert() function to convert from binary to numeric gives the following error:
Msg 8114, Level 16, State 2
Error converting type binary to type numeric.
Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Back to the top

MORE INFORMATION

The following script will replicate the problem: 
declare @x numeric
declare @y binary
select @y = 0x00
select @x = convert(numeric, @y)
select @x
Back to the top
APPLIES TO
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
Back to the top
Keywords: 
kbbug kbusage KB141664
Back to the top