Embedding Object In MySQL Embedding binary object in MySQL

[tatatititututoto 0]

I would like to ask, is it possible to embed binarry object into an MySQL database, like the MSSQL database & MS Access database. I would like to embed a few small txt based files into the mysql database. These text files are actually the settings of my web application so that the use can get the text file from the database. So any one with any clue, could u please gimme a hand here. Thanks mates.

[Houdini 0]

If you are talking about storing binary data in stead of textual data on a MySQL database then the answer is yes. It is the BLOB data type and there are four ypes of BLOB data

BLOB  types are TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB.

You can read more about these types of data and their use at the MySQL Page HERE.
This would be any kind of binary data such as avi mp3 or jpg and stuff along those lines. Hope that helps you out some.

[Hercco 0]

Why do you want to store a text file in a database? I mean after you get it from the database it'd be just the same text file and you'd need to parse it just like if you read it straight from the disk. Instead it would be much smarter to put the setting in a database table from which you can easily and fast read them to memory and then use.