help from Portugal
От | Pedro Miguel Guedes |
---|---|
Тема | help from Portugal |
Дата | |
Msg-id | 001101c39ec1$e7155ec0$1405a8c0@isla.pt обсуждение исходный текст |
Ответы |
Re: help from Portugal
|
Список | pgsql-general |
Dear sirs I have a crazy problem here. Nobody seems to known why. I am not a database expert nor do known much about Postgres. I am just a system administrator trying to move a database from one system to another. O the old system (slackware linux) the postgres was downloaded an compiled from source. O the new system (Red Hat 9.0) the postgres was installed from rpm precompiled binaries. Everything seemed ok. I pg_dump from the original. I createdb anf pg_restore on the destination. 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!??? if I do SELECT * FROM contactos WHERE empresa_nome ILIKE ´%NESTLÈ%´; it works! For queried material where accent on letters does not matter like NISA/nisa there are no problems with the query. The problem seems to be on accent on letters. So I thought maybe some stuff on charsets/encoding and I tried all the advices on the html/docs changing database and client encodings to LATIN1 (it was SQL_ASCII) to no help. Environ var like LANG and LC_ALL equal "pt_PT" on /etc/init.d/postgres. The guys who did the programming on the dadbase do not known any clues. Me, has I said, I am not expert and I a bit lost not knowing what to do next. Do you have any ideas? Thanks for any help Pedro Guedes PORTUGAL pmg01@netc.pt
В списке pgsql-general по дате отправления: