MySQL Forums
Forum List  »  Optimizer & Parser

Re: why left join can not use unique index?
Posted by: Rick James
Date: December 08, 2015 08:46PM

COLLATE utf8_bin versus the default of utf8_general_ci.

That is, be consistent on declaring the two fields that you are JOINing on.

Also, I recommend utf8mb4 throughout in place of utf8. There are a number of Chinese characters that are not in utf8.

Options: ReplyQuote


Subject
Views
Written By
Posted
2361
h h
December 07, 2015 08:30PM
Re: why left join can not use unique index?
984
December 08, 2015 08:46PM
861
h h
December 11, 2015 03:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.