On Sat, Apr 12, 2003 at 13:08:03 -0500,
"Jim C. Nasby" <jim@nasby.net> wrote:
> 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')
No.
P.S.
I double checked the name of the local and it is really 'en_US'.