Microsoft KB Archive/196769

= BUG: Error 7124 Documents Incorrect Size for ntext Data Columns =

Article ID: 196769

Article Last Modified on 10/15/2002

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.