NVARCHAR(MAX) string gets truncated when displayed in CF

Report · Sep 23, 2013

Hi, all. I have a stored procedure that returns a NVARCHAR(MAX) string of about 35,500 characters. When I execute the stored Procedure using Sql Server Manager, all 35,500 characters appear. However, when I try to display this string or store this in a Cold Fusion Variable on a .cfm page, only the first 32,000 characters get displayed.

Could someone please help me?

Thank you!

Report · Nov 13, 2013

Hi,

Try looking at the data source in the CF Administrator. Click on 'Show Advanced Settings', and look for the following fields:

CLOB (and BLOB) is not enabled by default, and if the Long Text Buffer is set to 32,000 for your data source, then that will probably explain the truncation you're seeing. If you enable CLOB, then the Long Text Buffer value becomes irrelevant (and the same for BLOB/Blob Buffer).

HTH.

Report · Jun 14, 2017

Enabling CLOB option in the Advanced setting allowed me to display 1150000 characters as well.

Apart from this, if we increase the Long Text Buffer (chr) value to a sufficient large value, that will also going to work.

Thanks MCTunes for the answer.