Post reply

NVarchar(max) field - Truncating on Display

  • January 11, 2017 at 11:51 am

    #339266

    We have fields in our database defined as nvarchar(max). People are putting in bibles of information into these fields. Its working great, the database is storing all the data... groovy.

    However, when we do selects from the table to display the data fields in our application's web pages, the fields are not displaying all the data. I'm assuming its because a select statement has a limit on how much data it will return?

    How do we get all the data in the field to show fully on the screen? We are using ColdFusion and the developers are just doing select field_name from table_name to display the data in their containers.

    Is there a server property I need to change?

  • January 11, 2017 at 12:17 pm

    #1922044

    Nevermind - I figured it out.

    ColdFusion views nvarchar(max) as a CLOB and our developers just needed to check a box in the data source configuration to accept CLOB data.

  • January 11, 2017 at 12:28 pm

    #1922049

    Thanks for posting back.

    Yes, display is controlled by the applications, not the database servers.

    One thing though - I haven't been in an environment with Cold Fusion for a lot of years so it may not apply but their used to be a size limit on CLOBs as well. So not sure if you will still run into truncation issues.

    Sue

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply