To BLOB or not to BLOB

[Anon]

I am interested in creating a database where members can fill out a page length profile, and update it whenever they want. I know this can be done using BLOB and a database, but doesn't this take up a lot of space?

Or is this the proper way to do this?

[Anon]

We have the concepts of BLOB and CLOB. If ur data involves some large binary data,store it in BLOB. If ur data includes only characters,u have the options to use VARCHAR or CLOB. CLOB gives u an advantage of storing large amount of Character data.The VARCHAR limits you to store 32K of data.

[Anon]

How much you can store in a surtain field typre depeds on what databas you use.

In MySQL, a VARCHAR can hold a max of 255 chars and a TEXT or BLOB can hold 64K.

If you are talking about just one page full of text, that is around 2-3K,
so a in MySQL, a TEXT field should do nicely.

For MySQL at least, a database server only uses as much of the max allowed storage as is needed for each row,so a TEXT field only takes up 5 bytes if you store 3 bytes in it (2 bytes overhead), not the full 64k.