search UTF8 character

[Doum]

Hi,
I would like to search in my comment specials characteres like icone (UTF8 icone ?) because when I want to add them in my own database with mariadb from calibre these characters cause problems with the sql Insert command.(not update)

Connection failed: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x8C\xB6\xEF\xB8...' for column `searchcal`.`articles`.`comment` at row 1

Exemple : i want to search 🪦/ 🖤 or others icones

🪦Ils vécurent heureux 🖤

PS : Firstly I would like to identify these characters in my comments and only then will I see how to process my SQL queries.

Thanks for your help

[kovidgoyal]

so search for them, calibre search works on all valid unicode text.

[Doum]

Thanks, i know, but my question is how to find all char icone in utf8 format not just one
Nevermind ....