QueryDatabaseTableRecord converting varbinary column to text?

grimcha — Tue, 17 Mar 2026 15:43:17 GMT

Edit: Tried using CSVWriter, XMLWriter and AvroWriter. All NG.

Nifi Version	2.5.0
Processor	QueryDatabaseTableRecord
Driver	com.microsoft.sqlserver.jdbc.SQLServerDriver

I have a requirement to pull varbinary data from a table however the output is always text. I expect a result starting with 0x. According to the jdbc driver within nifi, varbinary is supported however I see it gets converted to bytes. Is there a way to maintain the 0x format for the writer?

Notes

JDBC source for statement varbinary is supported at https://github.com/apache/nifi/blob/main/nifi-extension-bundles/nifi-extension-utils/nifi-database-utils/src/main/java/org/apache/nifi/util/db/JdbcCommon.java (line 360)

Re: QueryDatabaseTableRecord converting varbinary column to text?

grimcha — Tue, 17 Mar 2026 16:11:51 GMT

I have resolved this by forcing a CONVERT with a style of 1 to ensure binary output in the sql query with a 0x primer. Documentation here: https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver17

question QueryDatabaseTableRecord converting varbinary column to text? in Support Questions

QueryDatabaseTableRecord converting varbinary column to text?

Re: QueryDatabaseTableRecord converting varbinary column to text?