Krakozyabry in mysql database?

Question

PHP

I have a mysql database with latin1 encoding and collation latin1_swedish_ci. (only English text is supposed to be used) Website in utf8. Zend Framework 1 on the site uses utf8 for database operations.
Recently, in the database, the values ​​of almost all text fields were replaced with such things as:
value before: Have baby will travel
value after: Ü€l„„&ŽW4ó$ ®ôwzñAº:+T£”ìß‚¬*o
value before: Run of the farm
value after: ·ç›Ú]#æèèèf?6‰a
value before: Movie Maker
value after: ÅÚñ
I tried all the solutions from stackoverflow.com/questions/1344692/i-need-help-fi... but nothing worked .
Also, I still can't figure out if it was an encoding bug or a hack/virus.

Answer 1

Try to insert a request on the site immediately after connecting
SET NAMES utf8

Answer 2

You are most likely hacked

Answer 3

You've done the encoding, congratulations.
Backup in your hands as the easiest way.
have you tried something similar?
habrahabr.ru/post/137061
???

Answer 4

This does NOT look like an encoding bug.
It seems that random binary data was written to the database

Answer 5

In UTF8, Latin looks exactly the same as in Latin1, so it's definitely not an encoding bug, but problems with the table itself. Restore from backup.