Re: Case sensitive order by

On Fri, Apr 11, 2003 at 03:15:41PM -0500, Bruno Wolff III wrote:
> On Fri, Apr 11, 2003 at 23:49:12 +0530,
>   mallah@trade-india.com wrote:
> >
> > > I want to do case sensitve sorting on a varchar field.
> >
> > the default ordering is case sensitive , what makes u feel
> > otherwise , could u give some examples?
>
> That depends on the locale. In US_EN ordering is not case sensitive.
> (Unless to strings are the same excepting their case.)

Stupid question: would US_EN also result in where clauses being
case-insensitive? I'd like that behavior, but am currently doing it
using where lower(blah) = lower('search phrase')
--
Jim C. Nasby (aka Decibel!)                    jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"