Oh I get it and thanks for that explanation. I never knew about the max row size. I've never used note columns and never had a table with so many columns that I ever even came close to the row width limit in tables. So I'm left with still wondering whether to use note or varchar in my migration, but this helps. BTW is the varchar type also subjected to the row width limit, or is it exempted? That would make a difference.
On Wed, Oct 12, 2011 at 9:46 AM, <[email protected]> wrote: > 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). > > > -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
