Re: problem with query - Mailing list pgsql-general

From John R Pierce
Subject Re: problem with query
Date
Msg-id 52323F0C.1020605@hogranch.com
Whole thread Raw
In response to Re: problem with query  (Roberto Scattini <roberto.scattini@gmail.com>)
List 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



pgsql-general by date:

Previous
From: Bosco Rama
Date:
Subject: Re: problem with query
Next
From: Suzuki Hironobu
Date:
Subject: Re: 9.2 Replication in Ubuntu ; need help