Corrupted Files Microsoft Office 2007 Asp.net and SQL Server. WHY DOES SQL SERVER ADD AN EXTRA BYTE TO THE IMAGE COLUMN?
I am working on an ASP Website that stores files on database!! The website has been working great with no problems uploading and downloading any type of documents since 2001.

However, recently the customer noticed that all Microsoft Office 2007 documents "DOCX, XLSX,..." are corrupted when any user try to download them.

What I have noticed. That SQL server adds an extra byte to the DocumentContent (image column). Before uploading the document the content and length are fine. However, after they get stored, SQL Server adds an EXTRA Byte.... WHY?????

Many people on the internet provided a solution on how to download the file, which is great and it worked for me.

I am looking for an answer to this question... WHY DOES SQL SERVER ADD AN EXTRA BYTE TO THE IMAGE COLUMN?

Corrupted Files Microsoft Office 2007 Asp.net and SQL Server. WHY DOES SQL SERVER ADD AN EXTRA BYTE TO THE IMAGE COLUMN?
===

I am working on an ASP Website that stores files on database!! The website has been working great with no problems uploading and downloading any type of documents since 2001.

However, recently the customer noticed that all Microsoft Office 2007 documents "DOCX, XLSX,..." are corrupted when any user try to download them.

What I have noticed. That SQL server adds an extra byte to the DocumentContent (image column). Before uploading the document the content and length are fine. However, after they get stored, SQL Server adds an EXTRA Byte.... WHY?????

Many people on the internet provided a solution on how to download the file, which is great and it worked for me.

I am looking for an answer to this question... WHY DOES SQL SERVER ADD AN EXTRA BYTE TO THE IMAGE COLUMN?
