Re: help from Portugal

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: help from Portugal
Дата
Msg-id 3518.1067553113@sss.pgh.pa.us
обсуждение исходный текст
Ответ на help from Portugal  (Pedro Miguel Guedes <pmg01@netc.pt>)
Список pgsql-admin
Pedro Miguel Guedes <pmg01@netc.pt> writes:
> On the old system I did the query:
> SELECT * FROM contactos WHERE empresa_nome ILIKE �%nestl�%�;
> and it did work
> O the new system it does not produce nothing!???

I think you have the wrong locale setting in your new database.  The
database locale (at least LC_COLLATE and LC_CTYPE) is frozen at initdb
time.  It seems likely that you initdb'd with the wrong settings.
(pg_controldata can help you check this for sure.)

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Shared memory corrupted?
Следующее
От: "Chris White (cjwhite)"
Дата:
Сообщение: Another database recovery problem