Hey,
What is the best/standard way to allow for this. I'm writing it to a column in SQL at the point of upload, to allow users to search for specific file types. However, .xls and .xlsx have different content types (as does .doc and .docx!), and .xlsx doesn't
contain the word Excel in it:
.xls application/vnd.ms-excel
.xlsx application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.doc application/msword.docx application/vnd.openxmlformats-officedocument.wordprocessingml.document
Ideally I'd have a another column that just contains the common name, so excel, word, powerpoint, pdf, image etc.
I could, at worst, just do it on the extension (which I also write to a column), but that relies on people knowing the extension!
.doc
application/msword
.docx
application/vnd.openxmlformats-officedocument.wordprocessingml.document
...
Go to the complete details ...