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?
--
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/6a33619d-f9a8-4d60-8c69-a0c2f104388cn%40googlegroups.com.
