CODECUBE VENTURES

SQL Server Binary Data

So apparently, Image now stands for Binary ...

I'm working on a web application that requires me to store some binary data like Word doc's, Excel files, and other such data. Out of ignorance, I figured that varBinary was the best datatype for the job. I kept getting truncated binary data errors and I couldn't figure out how to make the field accept more the 8000 bytes.

Finally, I got around to doing some research at sqlteam.com (awesome site) and I learn that the dataType to use is actually Image which can store something crazy like 2 gigs.

go figure

Latest post: Digging Up the First Version of CodeCube

See more in the archives