SQL: order by

When specifying an order by, it should be possible to specify a collation.

An example that demonstrates the order of SQL operations with order by and union all is here.