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_ASCIIcan anybody point me in the right direction to solve this issue?-- Roberto ScattiniIf 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;SETpgon=# 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)
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_ASCIIcan anybody point me in the right direction to solve this issue?-- Roberto ScattiniIf you could tells what you are expecting, and what you are actually getting, that would be helpful.
we are using postgresql 9.1 from ubuntu packages and the database encoding is (sadly) SQL_ASCIIcan anybody point me in the right direction to solve this issue?-- Roberto Scattini
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных