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
% limit 10)
how can I return the search result to null, or remove the emoticon if it exist in the string again?
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 namehow can I return the search result to null, or remove the emoticon if it exist in the string again?
