Hi,

I want to look in table comment column comment-text for %Unsinn%
case-insensitive with this clause:

 where comment_text collate utf8mb4_general_ci like '%Unsinn%';

but this gives me error: COLLATION 'utf8mb4_general_ci' is not valid for
CHARACTER SET 'binary'

How can I proceed such a  collation?

Kind regards
Doc Taxon ...
_______________________________________________
Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org
To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org
https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/

Reply via email to