Subject | elementary question, blob versus varchar in ib |
---|---|
Author | bullardjuk |
Post date | 2002-03-15T18:45:25Z |
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
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