r/PHPhelp•
jurgonaut

Incorrect string value

I'm having trouble inserting some strings in the DB. My software versions:

  • mysql: MariaDB 10.2.38
  • php: 7.3.28

After I try to insert to the DB using PHP PDO, I get this error:

["22007",1366,"Incorrect string value: '\\xE2...<\/...' for column `DB`.`TABLE`.`data` at row 1"]

I tried setting the table collation to utf8mb4 but still the same error. I thin that the problem is caused by this emoji: 🔑. Any ideas how to solve this?

Posted Jul 21, 2021, 12:05 PM UTC

18
Loading comments…