Knowledge Base

BUG: Error 7124 Documents Incorrect Size for ntext Data Columns

Article ID: 196769

Article Last Modified on 10/15/2002

Microsoft SQL Server 7.0 Standard Edition

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.

Additional query words: prodsql unicode length datalength

Keywords: kbbug kbpending KB196769