On Fri, Aug 13, 2021 at 12:51 PM Paul <[email protected]> wrote: > Every time I use Sequel.like, it generates a LIKE with a COLLATE: > > (([XDR_TO] COLLATE Latin1_General_CS_AS) LIKE ('%blah%' COLLATE > Latin1_General_CS_AS) ESCAPE '\') > > that COLLATE makes the SQL run like 3x slower than without the collate.... > and I dont need the collate. > > MSSQL server tells me the column is collated as: > SQL_Latin1_General_CP1_CI_AS > > How to fix? >
Sequel uses COLLATE by default on MSSQL to ensure consistent behavior across databases. There isn't currently the ability to disable it, but considering the performance difference, I'll add support for that. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/CADGZSSduyueOc%2BjehD7V0arQEDZUEMMKeZU-s3MnWtiR-4LDNA%40mail.gmail.com.
