I am trying to store french string in mysql DB but it not get proper stored and changed some characters and not get display proper in my webpage
Original string: Bonjour Mr/Mme « Nom de famille du prospect », je suis « votre prénom » d’Europ Assistance La Téléassistance…
Stored string : Bonjour Mr/Mme « Nom de famille du prospect », je suis « votre prénom » d’Europ Assistance La Téléassistance…
I have tried with many solutions
Also tried many HTML functions but did not work character_set_name is utf-8
character_set_name is utf-8
Check the collation type of your MySql tables, it shloud be set at "utf8" to correctly encode accents on letters. You could also try "utf8mb4".