MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: JOIN is not returning expected results
Posted by: Peter Brawley
Date: January 30, 2018 08:22PM

> ERROR 1267 (HY000): Illegal mix of collations (latin1_general_cs,IMPLICIT)
> and (latin1_swedish_ci,IMPLICIT) for operation 'instr'

Some examples of collate fixes at https://stackoverflow.com/questions/3029321/troubleshooting-illegal-mix-of-collations-error-in-mysql, many other examples on the 'net.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
JOIN is not returning expected results
eric tse
January 15, 2018 12:13PM
Re: JOIN is not returning expected results
Peter Brawley
January 19, 2018 08:31AM
Re: JOIN is not returning expected results
eric tse
January 30, 2018 04:42PM
Re: JOIN is not returning expected results
Peter Brawley
January 30, 2018 05:33PM
Re: JOIN is not returning expected results
Peter Brawley
January 30, 2018 05:40PM
Re: JOIN is not returning expected results
eric tse
January 30, 2018 06:12PM
Re: JOIN is not returning expected results
Peter Brawley
January 30, 2018 06:18PM
Re: JOIN is not returning expected results
eric tse
January 30, 2018 07:38PM
Re: JOIN is not returning expected results
Peter Brawley
January 30, 2018 08:22PM
Re: JOIN is not returning expected results
eric tse
January 30, 2018 11:58PM
Re: JOIN is not returning expected results
eric tse
January 30, 2018 05:00PM


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.