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
2395
December 07, 2015 08:30PM
Re: why left join can not use unique index?
998
December 08, 2015 08:46PM
875
December 11, 2015 03:20AM
902
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.