Re: order by accents?

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@bioeng.washington.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
>