Skip to main content
ESP1906
Participant
Sep 23, 2013 8:01 PM UTC
Question

NVARCHAR(MAX) string gets truncated when displayed in CF

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 is closed to new replies. Start a new post to keep the conversation going.

2 replies

TheRealMC
Inspiring
Nov 13, 2013 8:11 PM UTC

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.

Translate
Himansu Sekhar Khuntia
Himansu Sekhar Khuntia
Participating Frequently
Jun 14, 2017 11:19 AM UTC

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.

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