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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.