On Fri, Aug 13, 2021 at 3:02 PM Jeremy Evans <[email protected]> wrote:
> 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. > Support added: https://github.com/jeremyevans/sequel/commit/7f108e60da8f13c3466599aa3294a3d2ea91ee2f 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/CADGZSSc6eb4cBS3TFiOYAm3dcKWWY6Zb4S83jLmPzViitv7Oqg%40mail.gmail.com.
