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? HTH, Bosco. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
