Re: order by accents?

From: ERIC Lawson - x52010 <eric(at)bioeng(dot)washington(dot)edu>
To: Patrick Coulombe <pcoulombe(at)mediacces(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: order by accents?
Date: 2000-07-07 17:19:10
Message-ID: Pine.GSO.4.10.10007071011580.25582-100000@gandalf.bioeng.washington.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Similarly, if I order by last name, last names consisting of two or more
words (e.g., "van Agoden") fall at the end of the list, after last names
beginning with zed. I would expect

Val, JB
Van, ER
Vanel, SV
Van Agoden, BT

or some similar ordering, but not

Val, JB
Van, ER
Vanel, SV
...
Zag, SH
Zuli, TP
Van Agoden, BT
etc.

I'm using version 6.5.3.

James Eric Lawson
Research Publications Editor III
National Simulation Resource

eric(at)bioeng(dot)washington(dot)edu

On Fri, 7 Jul 2000, Patrick Coulombe wrote:

> hi,
> if I do a query like this one :
>
> SELECT name from medias ORDER BY name
>
> name
> ----
> AAAA
> CCCC
> EEEE
> VVVV
> ZZZZ
> ÉCCC
> ----
> 6 rows
>
>
> Why the record : ÉCCC is at the end?
> HOW can I fix this?
>
> Thank you
> Patrick
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message sandis 2000-07-07 18:03:27 date comparison
Previous Message Patrick Coulombe 2000-07-07 16:53:14 order by accents?