Skip to content

Instantly share code, notes, and snippets.

@dylanbeattie
Created August 8, 2020 15:54
Show Gist options
  • Save dylanbeattie/7c79c172a1708d9c74c33d36b5d125c4 to your computer and use it in GitHub Desktop.
Save dylanbeattie/7c79c172a1708d9c74c33d36b5d125c4 to your computer and use it in GitHub Desktop.
DECLARE @places TABLE (name nvarchar(max));
insert into @places(name) values('Aarhus');
insert into @places(name) values('Berlin');
insert into @places(name) values('Zurich');
insert into @places(name) values('Aachen');
select name from @places order by name COLLATE Latin1_General_CI_AI
select name from @places order by name COLLATE Danish_Norwegian_CI_AI
select name from @places order by name COLLATE Finnish_Swedish_CI_AI
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment