storing files in database

hi

before years it says that store files on the hard drive and stor only links
in databse is that role true till now or new versions of sql work good even
if files stored in the database ?

and haw the client computer knows what type of data it is retriving like
..doc or .pdf or .avi , if its saved as binary or any other blob formats ?

thank you
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643