Re: problem with query
| От | Roberto Scattini |
|---|---|
| Тема | Re: problem with query |
| Дата | |
| Msg-id | CAApYZY8K_yKreTQiN8CaQ585H_OXB7wfAOrNyCjqbnYaT1gTJg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: problem with query (Bosco Rama <postgres@boscorama.com>) |
| Ответы |
Re: problem with query
Re: problem with query |
| Список | pgsql-general |
On Thu, Sep 12, 2013 at 7:02 PM, Bosco Rama <postgres@boscorama.com> wrote:
thanks On 09/12/13 14:49, Chris Curvey wrote:He's using 'ilike' in his query, so this is more likely to be a
> 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".)
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)
Roberto Scattini
В списке pgsql-general по дате отправления: