Thread: ORDER BY: lexicographic ordering of names

Bryan Herger wrote:

> 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:

Note to whoever answers: this is a frequent question, so consider adding
your answer to the FAQ on the wiki,

http://wiki.postgresql.org/wiki/FAQ

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Alvaro Herrera <alvherre@commandprompt.com> writes:
> Bryan Herger wrote:
>> 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:

> Note to whoever answers: this is a frequent question, so consider adding
> your answer to the FAQ on the wiki,

Done...
http://wiki.postgresql.org/wiki/FAQ#How_do_I_change_the_sort_ordering_of_textual_data.3F

            regards, tom lane

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