*need* to insert binary data into sql server image column

[silverspecv]

I know all the pro's and con's, but this is not my database, so I am stuck with it. I have a hard drive full of .TIF files that must be inserted into an sql database in a column of type IMAGE. I have used cffile action=readbinary to read it, use tobase64() to convert it, but what is the syntax for getting it into sql server?

 

[ETN]

Have you found your answer ? I'm stucked with the same problem...

 

[silverspecv]

No, I never did find an answer.. it is apparently quite complicated.

 

[ETN]

Here is a thread I just found:

http://www.tek-tips.com/viewthread.cfm?qid=456096

 

[silverspecv]

Yeah, I saw that one, but the problem I had is that I was using a pre-existing database, so I could not change data types.. The example shown by Teknology specifies that he used datatype of TEXT, while I was stuck with data type IMAGE.. And of course using text will work, but then you are not really storing binary, and you have to use the tobase64 and tobinary to convert it to text and back. The real solution will store true binary. But if you are running your own database and really need to store "binaries" in the table, and you don't mind using datatype of text, then it should work fine.