Pedro Miguel Guedes <pmg01(at)netc(dot)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