How can i store *.doc file in the MSSQL?

Question

Like Resume.doc

Answer 1

Hello,

You can use the BLOB data type to store .doc files in any database. But if your intention to search on these documents then you will be better off storing it in the File System. Unless you really have a requirement to store them in the database you should store them in the file system and just put a reference to the path in the database. This way your database will be smaller and your coding will also be simple. Using BLOBs and CLOBs (Long text objects) is complex in all databases.

Note that .doc has to be treated as a binary file even though it seems to have only text.

Answer 2

There is a concept of storing Binary Large Objects. But like all other DBMS and RDBMS, mssql suggests to store the file in a directory and store the reference to the file (like path) in a column.