2009/8/7 Jonathan Ellis <email@example.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.