Blobs stores large amount can you please tell me what is the limit i.e hw many kb of data can it store ? say 4000k like that.
For suppose if a 4000kb data can be stored using blob and the data stored in blob is 3600k what about the remaining data? will it allocates all the 4000kb data or will it allocates only 3600kb data? Like char(100) it will allocates all 100 bytes in memory and varchar(100) which is variable memory?