I have a 38,000 row table with a column that is currently
varchar(2500). Most of the content is 0-100 characters, but perhaps
20% uses about 500 characters or more. I want users to be able to
store up to about 2,500 characters if necessary.

I thought perhaps storage size would be more efficient if the column
was changed to text blob type. However when I change it there is
almost no change in table size. Is this correct behaviour?

Thanks
Mitch