Re: Case sensitive order by

Deepak Joglekar <deepak.joglekar@nebula-soft.com> writes:
> I want to do case sensitve sorting on a varchar field.

> That is I will have strings in the varchar field which will have
> character from ascii(32) to ascii(255). I want sort result by ascii
> values.

If you want a straight-ASCII sort without any funny locale sort rules,
you need to be careful to initdb in C locale.

            regards, tom lane