New answers tagged collation
No, you can't change the collating sequence without recreating the database.
sys.server_triggers is a server view, so it has the server collation. sys.triggers is a database view, so it has the database collation. You have a DB that has a collation different from the server. QED. Repro: create database foo collate Latin1_General_CI_AI use foo select tr.name from sys.triggers tr union all select tr.name from sys.server_triggers tr; ...
A query like this did the trick: select date, thing_id, email_domain collate utf8_unicode_ci from my_table where date = '2013-07-15' and thing_id = 119 and email_domain collate utf8_unicode_ci = 'comcast.net';
Top 50 recent answers are included