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 of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.