Incorrect Data Displayed for Binary Column When Querying SQL Server Table in DBeaver

[arsalanhub]

Description

I am encountering an issue when querying a SQL Server table in DBeaver. Specifically, the query:

SELECT MAX(__$start_lsn) FROM deleted.dbo.cdc_dbo_AideNote_CT_20240903

returns the correct data when executed directly in SQL Server Management Studio (SSMS). However, when the same query is executed in DBeaver, it returns garbled or incorrect data.

DBeaver Version

21.0.0

Operating System

Windows

Database and driver

Database: SQL Server
Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
SQL Server Version: Microsoft SQL Server 2016 (SP3-OD) (KB5006943) - 13.0.6404.1 (X64)

Steps to reproduce

Open DBeaver and connect to the SQL Server database.
Execute the query:

SELECT MAX(__$start_lsn) FROM deleted.dbo.cdc_dbo_AideNote_CT_20240903

Compare the results with the output from SQL Server Management Studio (SSMS). You can also try this by adding any binary column and check as shown.

Expected Result: The data returned by DBeaver should match the data returned by SSMS.

Actual Result: DBeaver displays incorrect or garbled data for the query.

Additional context

No response

[E1izabeth]

Hi, @arsalanhub
You can switch Binary format view to Hex to get the desired behavior. It's in context menu -> View/Format->Binary format

Additionaly, it's possible to view cell values in the Hex editor in Value viewer Panel.

[ask9]

@E1izabeth Shouldn't it by default dispalyed in hex-format based on data type?
Because it doesn't always contain a string.

[E1izabeth]

We don't think hex should be default display format. The binary data may not be hex - in this case showing hex by default is not a good idea. It's not so rare strings are stored in the binary column.