3

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.

firefly
  • 876
  • 2
  • 15
  • 42
  • 1
    Possible duplicate of [How to fix "Incorrect string value" errors?](https://stackoverflow.com/questions/1168036/how-to-fix-incorrect-string-value-errors) – Sand Of Vega Sep 22 '18 at 05:37
  • Actually I checked that page and do that stuff for example changing Database general_ci etc. but couldn't solve the problem. I think I need mych more specific answer for this. Very newbie at this stuff. – firefly Sep 22 '18 at 05:41

1 Answers1

1

I think this little change can help you 

'collation' => 'utf8mb4_unicode_ci'
Ragib Huda
  • 127
  • 5
  • 2
    still same error; PDOException::("SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE5' for column 'Addresses' at row 1") – firefly Sep 22 '18 at 06:13