View Single Post

   
  #7 (permalink)  
Old 02-28-2008, 09:47 AM
f-x.p@laposte.net
 
Posts: n/a
Default Re: reverse mutliple charset convert

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

Reply With Quote