Member Avatar for Haider85

I have some data in varbinary(max) from database and I have exported it to physical files. Some of these files were in jpeg so I was able to just add an extension .jpg to it and it opened. The rest are not jpeg files.

I have tried almost all the expected extensions from doc to pdf but none worked. I used UltraEdit to identify the "magic numbers" of the file so I can compare them to the ones found here:

http://www.garykessler.net/library/file_sigs.html

But here are the initial Hex values of the files in question:

File one: 48 53 BA 5F

File two: 48 53 17 C8 and so on...

Not found in the link above. My question is whether I can identify the actual extension/filetype of the file so that I can open it?

And yes, I already tried TrID and a number of online/offline file identifying tools.

One hint I got from the database is an extension scz but all I could find about this type is that it opens in SmartDraw application. Which obviously I tried. Didn't work.

Here is one sample file link for download:
Click Here

Thanks for your help.

  • 3 Contributors
  • 6 Replies
  • 434 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by rproffitt
Member Avatar for Haider85

@rproffitt, I am on Windows but yes, I have tried the equivalent "file" command in Windows.
I tried TrID as well as other Hex recognition softwares e.g. HexBrowser. Still nothing.

Edited by Haider85 because: Point out the memeber
Member Avatar for Suzie999

Also, try opening them with some zip/compression tool you have.

Member Avatar for Haider85

@Suzie999 I used Compression and Decompression Every tool, but i am not under stand 48 53 what format follow,

But here are the initial Hex values of the files in question:
File one: 48 53 BA 5F
File two: 48 53 17 C8 and so on...

Member Avatar for rproffitt

I think you need to consider that varbinary data may just be that and not a file stored in a database. Yes you may find jpeg images if that's the intent of the app and database but you've made an assumption that all varbinary items are files. What if they are not?

So back to the app to decode what is there.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.