Space for varchars is allocated only as needed. No need to use blobs at
all.
Actually, for all column types space is not preallocated if it is null.

HTH

Costas Droussiotis

bullardjuk wrote:

>
> I have avoided using 'blobs' because of added complexity. I have a
> table with a column 'comments varchar(40)'. Now my client wants this
> increaed to varchar(100). Only one in 20 records gets any comment
> added, so there is a lot of space characters about !
> It seems this is a case for a blob memo ...but what is the 'overhead'
> of a blob ? I am sure I read this somewhere but I have searched and
> cant re-find it. Was it 24 chars ??
> To this has to be added programming complexity but if I have to then
> I will.
> Any help welcome please.
> Dave
>