VARBINARY display in SQL Server

[expired user #7776]'s profile image [expired user #7776] posted 6 years ago in General Permalink

Seems to be an easily reproducible bug: in SQL Server databases VARBINARY(MAX) fields are displayed as 0x3F3F3F3F3F3F3F3F3F3F3F3F... regardless of the actual value.

ansgar's profile image ansgar posted 6 years ago Permalink

Which server version?

[expired user #7776]'s profile image [expired user #7776] posted 6 years ago Permalink

SQL Server 2017 Developer edition (the latest image that is currently available in docker: microsoft/mssql-server-windows-developer:latest)

ansgar's profile image ansgar posted 6 years ago Permalink

Ok, I did not yet test anything with the 2017 version, but it should not behave such different for blobs than older versions. I wonder if that value is generates by the server or if HeidiSQL does so.

[expired user #7776]'s profile image [expired user #7776] posted 6 years ago Permalink

When I view the same database in SQL Server Management Studio, everything is correct.

Please login to leave a reply, or register at first.