Home Forums SQL Server 2008 T-SQL (SS2K8) Detect / Determine data stored in a varbinary field RE: Detect / Determine data stored in a varbinary field

  • Quick thought, many file formats have a signature or a magical number at the start of the file which is unique for that format. There are quit few resources available such as File Signature Database, File Format Identification (forensics) and FileExtension.org[/url].

    If the first few bytes are all equal or higher than 32 / 0x20, then it is most likely a text file of some sort.

    😎