On Aug 15, 2:32 pm, Duc Qui <[email protected]> wrote: > I'm using jdbc:sqlserver (SQL Server 2008) and need a case sensitive > join. > > Currently, this is the only solution I found. > DB[:table1].join(:table2, "table1.column1 COLLATE > SQL_Latin1_General_CP1_CS_AS".lit => :table2__column2) > > Is there a better way?
Probably not. Sequel doesn't have support for COLLATE in its DSL. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
