All,
I am porting a database from MS SQL Server to Postgres. One of the tables contains a list of names, which I would like to list alphabetically. I noticed in the “O” names the following difference:
MSSQL:
O’Daniel
O’Neill
Oliveira
Oliver
While PGSQL sorts as if the apostrophe was not there:
O’Daniel
Oliveira
Oliver
O’Neill
I think the MSSQL output is more correct for listing names alphabetically. How can I configure or query PGSQL to get the same sort order?
Thanks,
Bryan