Re: problem with query

On Thu, 12 Sep 2013 19:07:04 -0300
Roberto Scattini <roberto(dot)scattini(at)gmail(dot)com> wrote:

> On Thu, Sep 12, 2013 at 7:02 PM, Bosco Rama <postgres(at)boscorama(dot)com>
> wrote:
>
> > On 09/12/13 14:49, Chris Curvey wrote:
> > > Is this just a case-sentitvity issue? if personas.apellido is a
> > > varchar field, then I think that's your trouble. (it would have
> > > to be citext in order for "nunez" = "NUNEZ".)
> >
> > He's using 'ilike' in his query, so this is more likely to be a
> > locale/charset/collation/encoding issue.
> >
> > Roberto, what encodings are in use by the client and the server/DB?
> >
> >
> hi bosco, in fact i believe that i have that problem... but i cant
> undestand why and how to fix it.
>
> the database has SQL_ASCII encoding, and my client... i am not sure,
> when i connect directly with psql from localhost i must set client
> encoding to SQL_ASCII or i receive an "invalid utf8 sequence" error...
>
> but the problem is there, from psql, from pgadmin and from php/apache
> (my webservers)

Without being an expert....dont use sql_ascii, dump, recreate the DB as
utf8 and you will get what you want.

>
>
> thanks
>
>