BInary column comparison fails in DV for Microsoft SQL Server
Issue
- Querying with a binary value in the criteria fails:
select * from Binarytable where ipv6= x'FFFF6BBE85D8'
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'FFFF6BBE85D8'.
Environment
- Red Hat JBoss Data Virtualization (DV) 6.2
- Microsoft SQL Server
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
