Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of paul.joseph.davis@gmail.com
 designates 209.85.212.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type:content-transfer-encoding;
        b=KC5f7cMIz3qTaoLRXwW1Kl5P5wtzSpEOeYMtkby6mWso/UOsZhrIGr7yDpG/kSrD4H
         rV2flwbBxGJLGZ2jXESdiGCBFmHUkd397WyObONtzxW83CZYnkrjSWAHN+yv3a2kKCie
         4WpYVYLGujh4GzoD4FDJTxu106lB8UeIw8rBo=
MIME-Version: 1.0
In-Reply-To: <BANLkTi=+jR8AciZFGjjsCgxy97vWuD5TMA@mail.gmail.com>
References: <BANLkTi=+jR8AciZFGjjsCgxy97vWuD5TMA@mail.gmail.com>
From: Paul Davis <paul.joseph.davis@gmail.com>
Date: Wed, 15 Jun 2011 09:37:20 -0400
Message-ID: <BANLkTi=3qrOAN6fVojYXKMB5pAnzsQ-yTA@mail.gmail.com>
Subject: 
 =?ISO-8859-1?Q?Re=3A_Does_couchdb_treat_o_or_=F8_or_=F4_the_same_way=3F?=
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

This is due to how ICU collation works and how its not at all
intuitive when it comes to accents and other things. I think the
example that gave me a mind bending introduction was to create a view
that emits "a", "aa", "A", "AA" only to be suprised that it gets
sorted as "a", "A", "aa", "AA" which is nutty if you're only familiar
with asciibetical.

HTH,
Paul Davis

On Wed, Jun 15, 2011 at 3:43 AM, Julien Gagnet <julien.gagnet@gmail.com> wr=
ote:
> Hi,
> First sorry if this was discussed but I couldn't find information.
>
> Given a simple document:
> { =C2=A0 "type": "user", =C2=A0 "name": "george"}
>
> And a even more simple view to find user with the start of their username=
:
> function(doc) {
> =C2=A0if (doc.type =3D=3D "user"){
> =C2=A0 =C2=A0emit(doc.name, doc);
> =C2=A0}
> }
> under User/user_by_name
>
> If I query this view with the start key 'geo' I get the expected
> 'george' user back:
> http://localhost:5984/test_db/_design/User/_view/user_by_name?startkey=3D=
%22geo%22&endkey=3D%22geo=E9=A6=99%22
>
> However if I search on ge=C3=B8 or ge=C3=B4 I still get george back:
> http://localhost:5984/test_db/_design/User/_view/user_by_name?startkey=3D=
%22ge=C3=B8%22&endkey=3D%22ge=C3=B8=E9=A6=99%22
>
> I not saying it's a bug but I would like to understand why this is
> happening. Is couch ignoring accented charater? How could I search for
> "th=C3=A9" (tea in french) and not getting back "the coffee"?
>
> Thanks for helping.
>
> Julien
>