Re: ntext getting truncated

Tech-Archive recommends: Speed Up your PC by fixing your registry


Thanks Tom and Russell for the help. Acually I am seeing in the table that
data is truncated. I am going to the table and going to the row and copying
the contents of the field corresponding field and pasting in notepad. This
shows data is truncated.

What do you mean "going to the table and going to the row"? As Russell
explained, this could simply be that you are stuck at the defaults for your
tool's display length; many tools silently display only the first n
characters. I would re-check your application settings to be absolutely
sure that the data is really truncated and not simply shown to you that way.

The fact that all of your descriptions seem to be getting "truncated" at
different lengths suggests to me that this is not a data loss issue, merely
a display issue. However I can't be sure until, as Tibor suggests, you
order from longest to shortest instead of most to least frequent.

A

.

Relevant Pages