Getting the text encoded value of a jpg file...

  • Thread starter Thread starter Charlie@CBFC
  • Start date Start date
C

Charlie@CBFC

Hi:

I want to set a default value of a varbinary(max) column in SQL Server. The
reason is my application databinds to a varbinary(max) column to display
pictures, and if there is no picture when record is created, I would like it
to default to a common picture. To do this, I will need text encoded
equivalent of binary file so I can paste it in as a column default. How do
I do this?

Thanks,
Charlie
 
do a hex dump of the image. then use this syntax:

insert table (@id, 0xfffffffffff)
 
Hi:

I want to set a default value of a varbinary(max) column in SQL Server. The
reason is my application databinds to a varbinary(max) column to display
pictures, and if there is no picture when record is created, I would like it
to default to a common picture. To do this, I will need text encoded
equivalent of binary file so I can paste it in as a column default. How do
I do this?

Thanks,
Charlie
Click to expand...

Why don't you upload the default file to your database and have it as
ID of 0. Then in control the insert of the default image in your SP,
if the jpg is dbnull then do an insert of the default file you have
you in your database.

if( @filedata is null)

select @imagedata=data from files where id=0


insert into files(imagedata) values(@imagedata)



- Manit
http://www.acriticsreview.com
 
Thanks guys. I downloaded a hex editor to get at the code.

Used it in SP. Works great.
 
Back
Top