BUG: Error 7124 Documents Incorrect Size for ntext Data Columns

ID: Q196769

The information in this article applies to:

Microsoft SQL Server version 7.0

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

Keywords : kbbug7.00
Version : winnt:7.0
Platform : winnt
Issue type : kbbug