View Single Post
Old 05-03-2025, 06:31 AM   #1
Doum
Connoisseur
Doum began at the beginning.
 
Posts: 66
Karma: 10
Join Date: Jun 2020
Device: Kobo Aura HD
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
Doum is offline   Reply With Quote