Got it;
Thanks!
Zhigang
-Original Message-
From: Hartmut Holzgraefe [mailto:hart...@skysql.com]
Sent: Thursday, September 11, 2014 1:44 PM
To: mysql@lists.mysql.com
Subject: Re: index collate
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
