support querying SQL SERVER varbinary fields - VisualCron - Forum

Community forum

gad
  •  gad
  • Paid support Topic Starter
2018-12-16T14:07:40Z
Hi,
currently when querying a "varbinary" fields VC task output displays only System.Byte[] instead of the actual data store in this field.
querying the same field using SQL Server management studio I get the correct result.
please add support for query such field.

Thank you,
Gad
thomas
2018-12-17T13:14:12Z
Hi

Just do a convert to varchar in your query:
vb is your varbinary field. The 0 at the end is to convert to text. Replace with 1, or 2 to get the HEX version instead. I think it's better to explicitly convert instead of relying on VC to guess what you want to convert to.

select convert(varchar(200), vb, 0)

gad
  •  gad
  • Paid support Topic Starter
2018-12-18T09:15:26Z
Hi Thomas,
your solution works perfect.
thank you!
Gad
Scroll to Top