Hi,
I found a very simple solution which I immediately published on my
site:
http://www.fxparlant.net/Mysql_Charset
I have noticed that the result of the double conversion ends with the
two characters 'ƒÂ' being added in every accented code:
é -> é
è -> è
ê -> ê
î -> î
At least, this works for french characters, I'm not sure it is the
same for german characters (Ö or ß), nor for asian characters
Therefore, I simply made an update query on the columns where the
problem happens. I simply erase the 'ƒÂ' characters.
UPDATE page SET `page_title` = REPLACE(page_title,'ƒÂ','');
UPDATE pagelinks SET `pl_title` = REPLACE(pl_title,'ƒÂ','');
It worked fine for me, but of course suche queries should be tested
first on a bigger scale.
Thank you for your help, and hope this helps.
François