Search code examples
sqlsql-serverimagevarbinary

Store both Image and Text in single column in SQL Server

I'm suppose to create reference table, to store key value pair.

Id
Key
Value

Thing is, i need to store both text and image as values, which kind of datatype should be better for this. most case ppl refer Varbinary. but i need to know which one was the best.

Thank You!

Solution

  • What if just store them as separate fields columns?

    Id bigint, Key varchar(50), ValueBlob varbinary(max),ValueString varchar(max)