Error in searchable TextColumn
I have attributes of name and phone using TextColumn searchable method.
the user sometimes accidentally paste the text in search input with emoticon in it, and these error appeared..
Error: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation 'like' (Connection: mysql, SQL: select * from
prospek where phone LIKE %asyaaAllahAlhamdul% or name LIKE %Maa syaa Allah Alhamdulillah.. 🤲🤲% limit 10)
how can I return the search result to null, or remove the emoticon if it exist in the string again?1 Reply
Not sure...but I'd sooner sort the collation out. It will be easier, and you're using a deprecated collation, so other potential problems will appear.
Emoticons are handled in search in the latest collations:
