Postgres Pro
Downloads
Home   >   mailing lists

Re: problem with query - Mailing list pgsql-general

From Roberto Scattini
Subject Re: problem with query
Date
Msg-id CAApYZY-R=c-gVi0fptQ-BS3FKStr7VLao97Ejd=E9vn+qWhj9Q@mail.gmail.com
Whole thread Raw
In response to Re: problem with query  (Chris Curvey <chris@chriscurvey.com>)
Responses Re: problem with query  (Chris Curvey <chris@chriscurvey.com>)
List pgsql-general
Tree view


On Thu, Sep 12, 2013 at 6:22 PM, Chris Curvey <chris@chriscurvey.com> wrote:


On Thu, Sep 12, 2013 at 4:34 PM, Roberto Scattini <roberto.scattini@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

pgsql-general by date:

Previous
From: Chris Curvey
Date:
Subject: Re: problem with query
Next
From: Chris Curvey
Date:
Subject: Re: problem with query