hex data correct or not? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

hex data correct or not?

Author

Topic

meenu.monu
Starting Member

8 Posts

Posted - 2010-07-19 : 08:47:43

dears,

advance thanks.

The following line showing the hex information of an image .

0x0001FFD8FFE000104A46494600010100000100010000FFDB0043000C08080A08080C0A0A0A0C0C0C0E101C121010101022181A141C28222A28262226262C303E342C2E3A2E2626364A363A40424646462A344C524C44503E444642FFDB0043010C0C0C100E1020121220422C262C4242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242FFC4001F0000010501010101010100000000000000000102030001FFD8FFE000104A46494600010100000100010000FFDB0043000C08080A08080C0A0A0A0C0C0C0E101C121010101022181A141C28222A28262226262C303E342C2E3A2E2626364A363A40424646462A344C524C44503E444642FFDB0043010C0C0C100E1020121220422C262C4242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242FFC4001F000001050101010101010000000000000000010203

This hex data i stored in sql table succesfully.In sql the field datatype is image .

now when i try to open this image in an aspx page , this image is not showing but a column is coming with a red colour crossmark.what is the reason behind this?

whether this is a hex picture information problem or not?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-07-19 : 14:47:27

Use ADODB Stream object to read the data from the database, and then display the data on your page.

N 56°04'39.26"
E 12°55'05.63"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources