MySQL Forums
Forum List  »  Portuguese

Re: ERROR 1267 (HY000): Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Posted by: Marcelo Altmann
Date: November 20, 2015 05:20PM

Diego,

Está fazendo joins ? ambas tabelas tem o mesmo charset / collation ?

Quando tu roda a procedure pelo console do mysql ela roda ?

Depois que tu seleciona o banco de dados (USE db_name), qual o retorno do comando \s ?

Está forçando o latin1 no banco de dados ( ALTER DATABASE test /*!40100 DEFAULT CHARACTER SET latin1 */; ) ?

Options: ReplyQuote




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.