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
