[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] help from Portugal
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2003-10-30 22:31:53
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
[prev in list] [next in list] [prev in thread] [next in thread]