Adding images In SQL Server Table

Question

Hi i have to add a image path to a column in table. i have the image file in a local folder. how to achieve this? i dont want to add the image fully as binary , i just want to add the image path to the column. thanx in advance.

use varchar as field type, get the relative/absolute path and store it. — Shantanu Banerjee
– Shantanu Banerjee, Commented Dec 4, 2012 at 10:57

The_Cthulhu_Kid · Accepted Answer · 2012-12-04 10:54:39Z

2

Just save it as a VARCHAR(260) and then you can access it from whatever program you are using/writing. [edited due to marc_s' comment]

answered Dec 4, 2012 at 10:54

The_Cthulhu_Kid

1,8691 gold badge31 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

marc_s Over a year ago

Since a path in Windows can be a maximum of 260 characters long - varchar(max) with a maximum of 2 GByte of data seems like a massive overkill..... varchar(260) would be just as good and doesn't carry any of the downsides of the max datatypes...

The_Cthulhu_Kid Over a year ago

I couldn't remember the max length of the address =)

Collectives™ on Stack Overflow

Adding images In SQL Server Table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related