BUG: Error 7124 Documents Incorrect Size for ntext Data Columns

ID: Q196769

The information in this article applies to:

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.

Additional query words: prodsql unicode length datalength 7.00
Keywords          : kbbug7.00 
Version           : WINNT:7.0
Platform          : winnt
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: December 5, 1998