data display in table

  • hello, i am having a table in which the value of one field is too long, and it isnot being displayed i tried nvarchar, ntext eveything but its not working any new ideas??

    thanks in advance

  • Have you explicitly converted (using CONVERT) the datatype into nvarchar?

  • What do you mean by "not displayed"? That is different from not having enough room in the column to hold the data to start with. QA defaults to 255 I think, you have to change an option to see more than that.

    Andy

  • Andy's right

    Go to Tools > Options > Results > Maximum characters per column to change this setting

    in QA

  • Max is 8192 characters.

  • quote:


    What do you mean by "not displayed"? That is different from not having enough room in the column to hold the data to start with. QA defaults to 255 I think, you have to change an option to see more than that.

    Andy


Viewing 6 posts - 1 through 5 (of 5 total)

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