Re: upper() vs. lower()

Поиск
Список
Период
Сортировка
От David Wall
Тема Re: upper() vs. lower()
Дата
Msg-id 002b01c0a5c8$765b21a0$5a2b7ad8@expertrade.com
обсуждение исходный текст
Ответ на upper() vs. lower()  (Soma Interesting <dfunct@telus.net>)
Список pgsql-general
I know that if you move towards unicode, you'll probably do better by going
to lowercase since I understand that there are more lowercase letters than
uppercase (for some odd reason!).  I think it's related to the fact that
some languages have multiple lowercase letters that will map to a single
uppercase letter, so there's great "distinct-ness" with lowercase.

David

> Is there any reason why everyone suggests to use upper() to do a case
> insensitive search rather than lower()?
>
> Will initcap() capitalize each word in a column, or just the first word?



В списке pgsql-general по дате отправления:

Предыдущее
От: "Brett W. McCoy"
Дата:
Сообщение: Re: Re: RPMs for PHP accessing PostgreSQL via ODBC over RedHat
Следующее
От: Tom Lane
Дата:
Сообщение: Re: function overloading / ambigous functions