couchdb-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Couchdb Wiki] Update of "View collation" by BrianCandler
Date Thu, 30 Apr 2009 13:33:52 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Couchdb Wiki" for change notification.

The following page has been changed by BrianCandler:
http://wiki.apache.org/couchdb/View_collation

The comment on the change is:
Add note about key ranges and UCA

------------------------------------------------------------------------------
  a A b B c C d D e E f F g G h H i I j J k K l L m M n N o O p P q Q r R s S t T u U v V
w W x X y Y z Z
  }}}
  
+ === Key ranges ===
+ 
+ Take special care when querying key ranges. For example: the query
+ 
+ {{{
+ startkey="Abc"&endkey="AbcZZZZ"
+ }}}
+ 
+ will match "ABC" and "abc1", but not "abc". This is because UCA sorts as
+ 
+ {{{
+   abc < Abc < ABC < abc1 < AbcZZZZZ
+ }}}
+ 
+ For most applications, to avoid problems you should lowercase the startkey, e.g.
+ 
+ {{{
+ startkey="abc"&endkey="abcZZZZZZZZ"
+ }}}
+ 
+ will match all keys starting with [aA][bB][cC]
+ 

Mime
View raw message