Search code examples
phpmysqldatabaselaravelutf8mb4

How can I fix "1366 Incorrect string value: '\xE5'

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.

Solution

  • I think this little change can help you 

    'collation' => 'utf8mb4_unicode_ci'