I have created a temporary table with a column "name". I have used Latin1_general_Cs_As as collation. In the table I included several rows (please examine the code).
create table #Names
name varchar(160) COLLATE Latin1_general_Cs_As
select 2, 'Byee'
select 1, 'Byl'
select 4, 'By'
select 3, 'Bÿ'
select 5, 'B'
After I execute the code, I get the following results:
I do not understand that the value "Byee" is ordered after "Bÿ". I would expect that the value "Byee" is positioned directly after "By". And I would expect that "Bÿ" is the last row.
Can somebody explain the results?