arthurpar
Notifications illegal mix of collations error
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
42 replies
Notifications illegal mix of collations error
https://github.com/filamentphp/filament/pull/8305#issuecomment-1711419170
I'm not sure that these two issues are linked. Here it says that updating to mariadb 10.6 resolved this bug but I'm on 10.11 so I also have this patch but still have an issue
42 replies
Notifications illegal mix of collations error
I replaced the
where of this line : https://github.com/filamentphp/filament/blob/3.x/packages/notifications/src/Livewire/DatabaseNotifications.php#L88
by whereJsonContains. I saw taht the where was on the json in the data column and i look in the laravel docs how to do a where on a json field. They talk about using whereJsonContains so i tried and it worked42 replies
Notifications illegal mix of collations error
I'm not sure... I thought I was in utf8_unicode_ci or utf8mb4_unicode_ci and I discovered this evening that it wasn't... Could trying to change everything to one of the other two solve my problem?
42 replies
