Re: Case sensitive order by - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Case sensitive order by
Date
Msg-id 3E972F51.8090501@cvc.net
Whole thread Raw
In response to Re: Case sensitive order by  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Is there  any tech docs or manual pages discussing using UTF-8 in Postgres?

Tom Lane wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: How can I get a column INT4 to be UNSIGNED ?
Next
From: P G
Date:
Subject: Has anyone seen this error? I cannot login into my database.