How does SSMS display varbinary data?

1 vote

2 answers

4624 views

                          When you store a .jpg file in a varbinary(max) column and then view the data in SQL Server Management Studio, it appears like "0xFFD8FFE000..."

Is this Hex Encoded or something?  What is SQL Server doing to generate this string?  Can it be converted to a valid JPG file?

Asked by Mike W (121 rep)

Nov 17, 2020, 10:57 PM
Last activity: Nov 18, 2020, 06:19 PM

How does SSMS display varbinary data?

Related Questions