On 09/11/2014 05:55 AM, Zhigang Zhang wrote: > The “CREATE INDEX Syntax” can not assign a collation. > > What collation to use to create a index on a column?
The collation used for an index on a textual column is the columns collation itself. You can't choose a different collation for the index, this would come down to having a "functional index" or "index on expression" as you'd need to apply CAST() or CONVERT() on the column first to change the collation. MySQL doesn't have support for expression based indexes though ... -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL - The MariaDB Company | http://www.skysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
