Is it possible to insert a zip file into SQL Server table?

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  June 13, 2007 at 1:46 pm

  #68748

  My client uses the data type, image, to insert his zip file. However, he could not unzip the file after downloading from SQL Server. What are the possible reasons?

  Many thanks in advance.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 14, 2007 at 8:17 am

  #712948

  How did he extract the binary from the system. I suspect he exported it incorrectly probably the wrong mime type.

  Here is an example of a BMP and C# from MS might help him understand what he did.

  http://support.microsoft.com/kb/309158