Ce sujet fait référence à mon autre post : http://wow-emu.fr/showthread.php?tid=1165
Les erreurs d'accents sont le compte-rendu de ce que vous aurez si vous ne faites pas comme dans le lien du tuto ci-dessus.
Pour les créatures :
Citation :UPDATE `creature_template` SET name = replace(name,'â','â');
UPDATE `creature_template` SET name = replace(name,'Ã','é');
UPDATE `creature_template` SET name = replace(name,'û','û');
UPDATE `creature_template` SET name = replace(name,'ï','ï');
UPDATE `creature_template` SET name = replace(name,'ê','ê');
UPDATE `creature_template` SET name = replace(name,'è','è');
UPDATE `creature_template` SET name = replace(name,'Ã','î');
UPDATE `creature_template` SET name = replace(name,'ô','ô');
UPDATE `creature_template` SET name = replace(name,'ÃÂ','é');
UPDATE `creature_template` SET name = replace(name,'À','à');
UPDATE `creature_template` SET name = replace(name,'â€',"'");
UPDATE `creature_template` SET name = replace(name,'–','à');
UPDATE `creature_template` SET name = replace(name,'…','!');
UPDATE `creature_template` SET name = replace(name,'Ã','à');
UPDATE `creature_template` SET name = replace(name,'àŠ','ê');
UPDATE `creature_template` SET name = replace(name,'à§','ç');
UPDATE `creature_template` SET name = replace(name,'“','"');
UPDATE `creature_template` SET name = replace(name,'�','"');
UPDATE `creature_template` SET name = replace(name,'‘',"'");
UPDATE `creature_template` SET name = replace(name,'cÅ“','œ');
UPDATE `creature_template` SET name = replace(name,'à¹','ù');
UPDATE `creature_template` SET name = replace(name,'Â',',');
Pour les items :
Citation :UPDATE `item_template` SET name = replace(name,'â','â');
UPDATE `item_template` SET name = replace(name,'Ã','é');
UPDATE `item_template` SET name = replace(name,'û','û');
UPDATE `item_template` SET name = replace(name,'ï','ï');
UPDATE `item_template` SET name = replace(name,'ê','ê');
UPDATE `item_template` SET name = replace(name,'è','è');
UPDATE `item_template` SET name = replace(name,'Ã','î');
UPDATE `item_template` SET name = replace(name,'ô','ô');
UPDATE `item_template` SET name = replace(name,'ÃÂ','é');
UPDATE `item_template` SET name = replace(name,'À','à');
UPDATE `item_template` SET name = replace(name,'â€',"'");
UPDATE `item_template` SET name = replace(name,'–','à');
UPDATE `item_template` SET name = replace(name,'…','!');
UPDATE `item_template` SET name = replace(name,'Ã','à');
UPDATE `item_template` SET name = replace(name,'àŠ','ê');
UPDATE `item_template` SET name = replace(name,'à§','ç');
UPDATE `item_template` SET name = replace(name,'“','"');
UPDATE `item_template` SET name = replace(name,'�','"');
UPDATE `item_template` SET name = replace(name,'‘',"'");
UPDATE `item_template` SET name = replace(name,'cÅ“','œ');
UPDATE `item_template` SET name = replace(name,'à¹','ù');
UPDATE `item_template` SET name = replace(name,'Â',',');
Voilà, si jamais vous avez d'autres problèmes d'accents dans votre db vous avez juste à modifier cette requête
PS: Ceci ne vient pas entièrement de moi il vient d'une partie de "vektor"