Occasionally I will get the following exception thrown from Laravel:
"class": "Illuminate\Database\QueryException",
"message": "SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xC0\xA7\xC0\xA2%2...' for column 'user_agent' at row 1 (SQL: update `sessions` set `payload` = testpayload, `last_activity` = 1663058232, `user_id` = ?, `ip_address` = ipAddress, `user_agent` = 1 ����%2527%2522 where `id` = blahblah)"
From what I have read, it most likely is that my table is not using the correct encoding and maybe a special character (something like Ö) is being used inside the user_agent from someone viewing the site and therefore it throws an error.
But checking that, I assume if I have the default Laravel setup, how others have not run into the same issue. Checking my setup:
config/database.php
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
^ and confirming in the db itself, this is what I am using.
I then suspected maybe when I upgraded from Laravel 5.x > 7.x maybe a migration changed or something and I should be using a different charset. But checking migrations and also the db config for version 7, nothing has changed.
Laravel Version: 7.30.4
Mysql Version: 5.7.33-log
Anyone seen this before or point me in the right direction?