1 Reply Latest reply: Nov 13, 2013 12:11 PM by MCTunes RSS

    NVARCHAR(MAX) string gets truncated when displayed in CF

    ESP1906 Community Member
    ESP1906 Sep 23, 2013 1:01 PM

      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!

        • 1. Re: NVARCHAR(MAX) string gets truncated when displayed in CF
          MCTunes
          MCTunes Nov 13, 2013 12:11 PM (in response to ESP1906)

          Hi,

           

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

           

          Capture.PNG

          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.