Re: problem with query

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with query
Date: 2013-09-12 22:24:12
Message-ID: 52323F0C.1020605@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/12/2013 3:03 PM, Roberto Scattini wrote:
> yes, is just a case-sensitivity issue. yes, is a varchar field.
> but what i dont understand is why the problem of "insensitivity" is
> only with ñ (lower). i mean, if i remove my ñ (and subsecuent chars),
> both querys return the same rows:

SQLASCII means its just 8 bit octets, and only standard USASCII
characters are recognized, which doesn't include ñ (what encoding is
that in, anyways?)

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Suzuki Hironobu 2013-09-12 22:40:59 Re: 9.2 Replication in Ubuntu ; need help
Previous Message Bosco Rama 2013-09-12 22:22:54 Re: problem with query