#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.