Pedro Miguel Guedes <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
