I think you want CONVERT(comment_text USING utf8mb4) You need to convert to utf8 before you can collate as utf8.
I suspect this query would be pretty slow. -- Bawolff On Saturday 1 June 2024, Martin Domdey <dr.ta...@gmail.com> wrote: > 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/
