[SQL] Query text column with exactly same order in MS SQL and PostgreSQL

I have a table with same text column in two different DBMS - MS SQL Server and PostgreSQL.

I need query this table with exactly same order by this text column (it doesn’t matter if it’s in alphabetical order, it’s important that it’s in the same order). I need this query to compare tables content by this column.

What I need to write in ORDER BY clause?

PostgreSQL 14+, MS SQL 2008R2+

I need a solution independent of Collation, OS Language, Codepage, Text column Type (varchar/nvarchar/text/citext/...)

I would be happy to sort by the order of some hash, but a similar question arises here - how to get the same hash value of some text in PostgreSQL and MS SQL?

Continue reading...