http://sn.1w6.org/file/lnxw48-20150314T182854-9k9xk4p.html
#MySQL #database now has the ability to "autogenerate" columns from existing columns. http://url.federati.net/Jbrxs gives an example of use, but that example actually demonstrates that it should be possible to have case-sensitive and case-insensitive indexes on the same column (also ascending and descending order indexes and so on). No word on whether this is also in #MariaDB and #Percona yet.