As Dennis mentioned, there is a fixed-length row size. It is common if you have a table with a note field, that you can add a new column to the table and see the message "data has been truncated" or something to that effect. What that means is that for some of the rows, the new column pushed the row over the max size, so it will automatically truncate data from the note field for that row. So if you have a table with a whole bunch of columns, and you anticipate large note data, then you might experience truncating.
Karen In a message dated 10/12/2011 11:24:45 AM Central Daylight Time, [email protected] writes: > I don't understand the second sentence. How would the other columns > affect it? BTW I'm interested in the formatting available in varchar, > although > much of that functionality may be unused because of report formatting (it > would be weird to have different formatting for varchar columns than for > the rest of the report, although I can envision some uses for it, such as > imported stuff).
