S
S
Scronheim2017-04-03 11:37:34
MySQL
Scronheim, 2017-04-03 11:37:34

Illegal mix of collations for operation '='?

Laravel throws an error

QueryException in Connection.php line 770:
SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation '=' (SQL: select count(*) as aggregate from `azimuth_parts_complex` where `sn` = пермь or `make_date` = пермь or `capabilities` = пермь or `place` like %пермь% or `enclosure` = пермь or `dongle_id` = пермь or `ipaddress` = пермь or `login` = пермь or `password` = пермь or `metrologypwd` = пермь or `comment` = пермь)

Base encoding utf8, comparison utf8_unicode_ci, the table is still the same

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question