CODEWITHSUNDEEP
phpmysqldatabaselaravelutf8mb4
firefly
firefly

Reputation: 906

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.

Upvotes: 3

Views: 4297

Answers (1)

Ragib Huda
Ragib Huda

Reputation: 127

I think this little change can help you 

'collation' => 'utf8mb4_unicode_ci'

Upvotes: 1

Related Questions