Tag Info

New answers tagged

2

No, you can't change the collating sequence without recreating the database.


5

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; ...


0

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