如何修复“1366不正确的字符串值：'\ xE5'

Question

I checked other topics and changed my database to this "utf8mb4_general_ci" and also I am trying to insert data with laravel thats why I changed laravel Mysql Database config to this;

'charset' => 'utf8mb4', 'collation' => 'utf8mb4_general_ci',

but still when I try to migrate data to database table still this error pops up.

Invalid datetime format: 1366 Incorrect string value: '\xE5' for column 'Addresses' at row 1")

What am I missing here? Also i am trying to add Japanese Text.

Answer 1

I think this little change can help you

'collation' => 'utf8mb4_unicode_ci'