2009/8/7 Jonathan Ellis <jbellis@gmail.com>
The default OPP now does comparisons based strictly on byte order, and
is no longer collation aware.  This is a better default choice for
those who don't need collation since it's much faster.  If you do need
collation, the old partitioner is still available as CollatingOPP:


That is a very good idea; the collation support was somewhat confusing anyway.

If you need to put case-insensitive data into keys to do lookups / range scans etc, just convert them to lowercase at insert-time. You can store the original capitalisation in a column value.

Also it makes it consistent with what (e.g.) memcached does.

Mark