RE: index collate

2014-09-10 Thread Zhigang Zhang
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 assig

Re: index collate

2014-09-10 Thread Hartmut Holzgraefe
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

index collate

2014-09-10 Thread Zhigang Zhang
I have a question. The “CREATE INDEX Syntax” can not assign a collation. What collation to use to create a index on a column? Thanks Zhigang.