search UTF8 character
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
|