BUG: Error 7124 Documents Incorrect Size for ntext Data Columns (196769)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q196769
BUG #: 51851 (SQLBUG_70)

SYMPTOMS

If you use a READTEXT statement on a column of ntext type and error 7124 occurs, the byte length of the column is reported instead of the character length in the error message.

WORKAROUND

To get the correct character length, divide the length value reported in the error by 2.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

MORE INFORMATION

Here is an example of the error on a ntext column of length 4. The error was generated by asking for 5 characters using READTEXT run from SQL Query Analyzer:
Server: Msg 7124, Level 16, State 1, Line 10
The offset and length specified in the READTEXT
statement is greater than the actual data length of 8.
Modification Type:MajorLast Reviewed:10/15/2002
Keywords:kbBug KB196769
©2002 Microsoft Corporation. All rights reserved.