Hi Brian, thank you, this helps.
Kind regards Doc Taxon ... Am Sa., 1. Juni 2024 um 20:28 Uhr schrieb Brian Wolff <bawo...@gmail.com>: > 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/
_______________________________________________ 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/
