Hi Brian, thank you, this helps.
Kind regards Doc Taxon ... Am Sa., 1. Juni 2024 um 20:28 Uhr schrieb Brian Wolff <[email protected]>: > 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 <[email protected]> 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 -- [email protected] > To unsubscribe send an email to [email protected] > https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/
_______________________________________________ Wikitech-l mailing list -- [email protected] To unsubscribe send an email to [email protected] https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/
