Skip to main content
E
ESP1906
Participant
September 23, 2013
Question

NVARCHAR(MAX) string gets truncated when displayed in CF

  • September 23, 2013
  • 1 reply
  • 3679 views

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!

This topic has been closed for replies.

1 reply

T
TheRealMC
Inspiring
November 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.

Himansu Sekhar Khuntia
Himansu Sekhar Khuntia
Participating Frequently
June 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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices