How to make an order case insensitive

Question

I am starting to work with MongoDB and NoRM and I would like to make orderBy which is not sensitive to Ccase, is this possible?

Thanks for the help!

Answer 1

It seems impossible (read http://groups.google.com/group/mongodb-user/browse_thread/thread/1491cfb04ec706b3/c2050f57daea3836?lnk=gst&q=insensitive#c2050f57daea3836 ).

You can save the value twice, once in a mixed case and once in uppercase. You can index the uppercase column.