Why is the maximum varchar length less than 8000 bytes?

Question

So, I have a stored procedure in a SQLServer 2005 database that retrieves data from a table, formats the data as a string, and puts it in the output variable varchar (max).

However, I notice that although len (s) reports that the string should be> 8000, the actual string that I get (through the SQLServer output window) always truncates to <8,000 bytes.

Does anyone know what could be the reasons for this? Many thanks.

Answer 1

The output window itself trims your data. The variable itself contains data, but only the first X characters are displayed in the window.

, , .NET, .

Answer 2

SQL Server Management Studio? , ( 2008 , " | | " | SQL Server | | , | , .

Answer 3

, .

MS Access . , Access Management Studio Query Analyzer, , .

Answer 4

However, I notice that although len (s) reports that the string should be> 8000

I also got into a problem with SQL Studio :), but not a maximum length of 8000 bytes, or 4000 for nvarchar (unicode).

Any case when the column data type is actually text or ntext , and you go to varchar ?