Jump to content

php displaying part of binary image from MSSQL


doubleS

Recommended Posts

I have been tasked with creating a web view only from a MSSQL table. There is a binary (field attributes list it as an image) image field that needs to be displayed within the list of results. I am having difficulties displaying the entire picture, only the top part seems to be showing. I have hunted around the net and within these forums for help and had no luck finding any information on the issue. Any type of information would be helpful at this time.

Link to comment
Share on other sites

When an image's data is written to a file, it stored the data from top to bottom, so if the image shows (just say) 10% then messes up, and fails to show the rest, then it would probably mean the data is damaged,

create a backup and them add another image and try viewing that, also check if theirs a limit on the amount of data that field can hold

Link to comment
Share on other sites

The data doesn't appear to be damaged when at first we were going to use Oracle, and after doing a data migrate from MSSQL to MS Access to Oracle there are no issues. The higher ups have shot down the use of Oracle with this project due to time constraints and some background work that would have to be done to Oracle to meet the scope of the project. So, I am forced to use MSSQL which needs to be able to accurately read any data that gets dumped from the original MSSQL database on a server that I do not have permission to access.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.