| From: | Dennis Gearon <gearond(at)cvc(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Deepak Joglekar <deepak(dot)joglekar(at)nebula-soft(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Case sensitive order by |
| Date: | 2003-04-11 21:10:41 |
| Message-ID: | 3E972F51.8090501@cvc.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Is there any tech docs or manual pages discussing using UTF-8 in Postgres?
Tom Lane wrote:
> Deepak Joglekar <deepak(dot)joglekar(at)nebula-soft(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Chittenden | 2003-04-11 21:16:17 | Re: [GENERAL] medical image on postgreSQL? |
| Previous Message | Dennis Gearon | 2003-04-11 21:09:41 | Re: How can I get a column INT4 to be UNSIGNED ? |