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: Diego Felipe Diego
Date: November 20, 2015 01:44PM

Fala Marcelo, tudo blz?

Então, eu tentei deixar tudo com latin1, mas mesmo assim não foi.
Também acabei de tentar executar o SET NAMES 'latin1' COLLATE 'latin1_swedish_ci'; mas o resultado foi o mesmo.

Olha como está o meu MySQL 5.6

mysql 5.6> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

Ele está idêntico ao MySQL 5.0

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.