The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
MS-SQL Image data type
rfalias
Registered User regular
Registered User regular
What is the easiest way to retrieve the data for this field type? I've never encountered the 'Image' or 'Picture' data type before...
Can it be read directly into HTML if I query that field and return it into img tags?
Can it be read directly into HTML if I query that field and return it into img tags?
rfalias on
0
Posts
Alternatively, don't store binary data in SQL.
It makes baby Jesus cry.
we also talk about other random shit and clown upon each other
Well, it is not by my choice. I'm just a victim of the crime.
Additionally, is there a way to determine the mime type that field is, or am I going to have to try every extension until I get it?
I don't know why we have this system in the first place, but our DBA's don't know a goddamn so I'm stuck figuring it out
Double edit: What is even gayer is that the field on the front end is TEXT.
To get the image in the page: The behind-the-scenes code:
if (PictureID > 0) { Picture picture = PictureManager.GetPictureByID(PictureID); if (picture != null) { using (MemoryStream ImageStream = new MemoryStream(picture.PictureBinary)) { using (System.Drawing.Image MyImage = System.Drawing.Image.FromStream(ImageStream)) { using (MemoryStream OutputStream = new MemoryStream()) { if (Width > 0 || Height > 0) { _GetImageDimensions(ref Width, ref Height, MyImage); Bitmap bmp = new Bitmap(Width, Height); Graphics g = Graphics.FromImage(bmp); g.DrawImage(MyImage, 0, 0, bmp.Width, bmp.Height); bmp.Save(OutputStream, ImageFormat.Gif); } else { MyImage.Save(OutputStream, ImageFormat.Gif); } //img.Save(ImageStream, ImageFormat.Png ); Response.ContentType = "image/gif"; Response.BinaryWrite(OutputStream.ToArray()); Response.End(); } } } } }SC2 NA: exoplasm.519 | PA SC2 Mumble Server | My Website | My Stream
Which version of MS SQL are you using? I'm using 2005 where I work and I can see the data stored in a binary field if I SELECT the field from a query window. The part of the the data near the beginning should give you some clue, for example, I'm looking at a PNG file in a text editor right now and I'm seeing "PNG" appear twice.
Is all that really necessary though? I don't know if this is the right way to do things, but a few years ago I wrote a PHP page that basically just echo'd out the value from a text type MySQL field and set the header mime type as some image type (can't remember).
In the case of ASP (I assume, from the mention of ADO) couldn't you just set the response.contenttype and response.write everything out?
His code is not as complex as it looks, and he's got an extra if block in there that the OP probably won't need.
That's the standard way of doing it in .NET. There are some technical reasons as to why you have to jump through all those object hoops, but regardless, it's probably 4 times faster than the equivalent PHP function.
Probably the #1 reason for using his code is that you can also run an image off the filesystem through that function without any changes to the code, instead of *just* SQL queried binary.
we also talk about other random shit and clown upon each other
Ah OK, thanks for that explanation.
When I set the ADO Stream to Binary, it would return no output, as soon as I move to text, it worked fine but was garbage about
I suppose that's what I get when it's proprietary crap.
Thanks for the help though!
For fun here is what it returned!
湕扡敬琠档牡⁴湯愠瀠瑡敩瑮椠䍓⹍吠捩敫⁴㘲〱㔰ⴠ匠整敶獮湯慊敲
Maybe it says, "Me love you long time"