Re: LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?
Дата
Msg-id 4113.1264183420@sss.pgh.pa.us
обсуждение исходный текст
Ответ на LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?  (Daniel Cristian Cruz <danielcristian@gmail.com>)
Список pgsql-admin
Daniel Cristian Cruz <danielcristian@gmail.com> writes:
> I found this problem, where 'ã' MUST be ILIKE 'Ã' (PostgreSQL 8.2.12, RedHat
> x86_64):

Is your database encoding iso88591?  IIRC, 8.2 will try to warn you if
the encoding doesn't match the locale setting, but it doesn't completely
refuse nonsensical combinations.  However, a nonsensical combination
could easily cause bad results from upper().

            regards, tom lane

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

Предыдущее
От: Daniel Cristian Cruz
Дата:
Сообщение: LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?
Следующее
От: Michael Monnerie
Дата:
Сообщение: max_fsm_pages question