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.
Subject
Views
Written By
Posted
2475
December 07, 2015 08:30PM
Re: why left join can not use unique index?
1031
December 08, 2015 08:46PM
913
December 11, 2015 03:20AM
945
December 15, 2015 11:08AM
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.