On Thu, Sep 12, 2013 at 6:22 PM, Chris Curvey <ch...@chriscurvey.com> wrote:
> > > On Thu, Sep 12, 2013 at 4:34 PM, Roberto Scattini < > roberto.scatt...@gmail.com> wrote: >> >> >> we are using postgresql 9.1 from ubuntu packages and the database >> encoding is (sadly) SQL_ASCII >> >> can anybody point me in the right direction to solve this issue? >> >> -- >> Roberto Scattini >> > > If you could tells what you are expecting, and what you are actually > getting, that would be helpful. > > hi chris, sorry, the query with ilike '%NUÑEZ%' is returning 4 rows and the query with ilike '%nuñez%' is returning 0 rows. a simplified version of the query with his results: pgn=# set client_encoding = SQL_ASCII; SET pgon=# SELECT DISTINCT p.id, p.apellido, p.nombre FROM personal.personas AS p WHERE p.apellido ilike '%nuñez%'; id | apellido | nombre ----+----------+-------- (0 rows) pgon=# SELECT DISTINCT p.id, p.apellido, p.nombre FROM personal.personas AS p WHERE p.apellido ilike '%NUÑEZ%'; id | apellido | nombre -------+----------------+----------------- 39489 | NUÑEZ | JUAN 39937 | PEREZ NUÑEZ | FRANCISCO 39498 | NUÑEZ ESQUIBEL | RICARDO RODOLFO 40220 | NUÑEZ VERA | MANUEL SANTIAGO (4 rows) thanks! -- Roberto Scattini