Data Type

Hi,

I am building a database where I am inserting a file of size around 250K to 500K. The database runs to more than a GB. The file is a html page. I would like to know which data type to use for the file storage.

Depends on database program. In MSSQL, you can just use text and it'll easily hold 500K. I tried looking for a upper limit on text sizes in MSSQL and MS wasn't very specific, but I know it's very large.

If you are using MySQL, then the following text columns are available, probably medium or long text will suite your needs.

TINYTEXT and TINYBLOB -- A TEXT/BLOB with max length of 255 characters.

TEXT and BLOB -- A TEXT/BLOB with max length of 65535 characters.

MEDIUMTEXT and MEDIUMBLOB -- A TEXT/BLOB with max length of 16777216 characters.

LONGTEXT and LONGBLOB -- A TEXT/BLOB with max length of 4294967295 characters.

If you are using some other database program, i hope someone else can help you. those are the only two i know.

---John Holmes
---www.SepodatiCreations.com

Thanks for your immediate reply.

I am using a MySql as my database backend.