AAA
Reputation: 31
How to get file type from binary data in SQL Server File table?
I want to get file type from binary data in a column File_Stream in FileTable.
In FileTable, there is File_Type column but it's not reliable.
Pay attention to the following queries:
These files are the same!
Upvotes: 0
Views: 1290
Answers (1)
Dan Guzman
Reputation: 46241
The file_type column value is derived from the file name, not the binary contents of the file. SQL Server has no notion of what the actual binary contents represent.
Upvotes: 3
Related Questions
- SQL Server : files as binary text extract
- How to convert Binary data in column to a file?
- How to extract the text contents of files stored as binary in database
- Binary Type to Actual Binary
- How to get individual bytes from a SQL binary field
- SQL Server read csv binary from table
- Programatically find out a file type by looking its binary content. Possible?
- Extract Binary Data from SQL Server using T-SQL
- How to detemine content type of binary data in the image field of SQL Server 2008?
- How can I identify a file type from a blob/filestream?