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.

high roller
  • 850
  • 1
  • 11
  • 34
  • 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. – high roller Sep 22 '18 at 05:41

1 Answers1

2

I think this little change can help you 

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