Notifications illegal mix of collations error
Hi,
I tried to set up notifications for my Filament application. I followed the documentation for migrating the notifications table and created it. Afterward, I added
However, when I try to access the panel, I encounter a collation error. I attempted to change the table collation between utf8mb3_general_ci and utf8mb3_unicode_ci, but it didn't make any difference. I managed to fix the error by changing the
Thanks in advance.
https://github.com/filamentphp/filament/blob/3.x/packages/notifications/src/Livewire/DatabaseNotifications.php#L88
I tried to set up notifications for my Filament application. I followed the documentation for migrating the notifications table and created it. Afterward, I added
->databaseNotifications()However, when I try to access the panel, I encounter a collation error. I attempted to change the table collation between utf8mb3_general_ci and utf8mb3_unicode_ci, but it didn't make any difference. I managed to fix the error by changing the
wherewhereJsonContainsThanks in advance.
https://github.com/filamentphp/filament/blob/3.x/packages/notifications/src/Livewire/DatabaseNotifications.php#L88
GitHub
A collection of beautiful full-stack components for Laravel. The perfect starting point for your next app. Using Livewire, Alpine.js and Tailwind CSS. - filamentphp/filament
Solution
Hi,
I managed to make it work by deleting my db completely and recreating it in utf8mb4_unicode_ci so it's definitely an encoding error... I'll just have to find out how to convert my current db to utf8mb4_unicode_ci I think I did it wrongly last night. Thank you very much for the help
I managed to make it work by deleting my db completely and recreating it in utf8mb4_unicode_ci so it's definitely an encoding error... I'll just have to find out how to convert my current db to utf8mb4_unicode_ci I think I did it wrongly last night. Thank you very much for the help
