Changes between Version 1 and Version 2 of Ticket #36571, comment 1


Ignore:
Timestamp:
Aug 25, 2025, 4:39:52 PM (4 weeks ago)
Author:
Jason Hall

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #36571, comment 1

    v1 v2  
    1 Would `CAST(... AS BINARY)` be enough here?  This only casts the pattern and not the column?  That might lead to subtle differences depending on the column's collation or affect index usage.  `COLLATE ..._bin` be closer to the old `LIKE BINARY`, since it applies a binary collation to the column and the pattern?
     1Would `CAST(... AS BINARY)` be enough here?  This only casts the pattern and not the column?  That might lead to subtle differences depending on the column's collation or affect index usage.  Would `COLLATE ..._bin` be closer to the old `LIKE BINARY`, since it applies a binary collation to the column and the pattern?
Back to Top