ID Number: Q80632
1.10 1.11
OS/2
buglist1.10 buglist1.11 fixlist1.11k3
Summary:
Problem ID: PRSQL9201008
SYMPTOMS
Assume the following table "textest" has a column called "col1",
which is defined as a text data type. The following query will
GP fault SQL Server:
declare @val binary(30)
select @val = textptr(col1)
from textest
readtext textest.col1 @val 1 5
go
CAUSE
SQL Server incorrectly handles the use of a text pointer that is
defined as a binary data type, rather than varbinary.
WORKAROUND
Change the data type of @val to varbinary(30) instead of binary(30).
STATUS
Microsoft has confirmed this to be a problem in SQL Server versions
1.1 and 1.11. This problem was corrected in the version 1.11 K3
patch to SQL Server version 1.11. This patch can be obtained from
Microsoft Product Support Services. For more information, contact
your primary support provider.
Additional reference words: 1.10 1.11 1.11k3 datatype gp-fault