Re: Case sensitive order by

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема Re: Case sensitive order by
Дата
Msg-id 3E972F51.8090501@cvc.net
обсуждение исходный текст
Ответ на Re: Case sensitive order by  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: How can I get a column INT4 to be UNSIGNED ?
Следующее
От: P G
Дата:
Сообщение: Has anyone seen this error? I cannot login into my database.