Il 18-03-2009 21:32, Bryan Herger ha scritto:
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?
Some time ago I had a problem with string sorting related to my locale (but with "*" instead of "'"), now all works adding
"ORDER BY column USING ~<~".

I did I try with your data but I obtain the same sorting of MSSQL both in my locale and using ~<~.

Edoardo


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to