By jocrenalix on

Hi everyone,

Is there anyone who experienced these strange characters appearing on the sites replacing " ", and ' ' with different characters? I give you a link http://samuiexpress.net/?q=node/1034 ...

I have been seaching in the forum but seems no one had or is having this problem. I already contacted my host but they ae unable to fix the database encoding. This site is relatively large with over a thousand nodes, and remaking it is a bit tough.

Any suggestion is highly appreciated andd thank you in advance.

⋅ Categories: Drupal 4.7.x

Comments

cog.rusty’s picture

cog.rusty commented

It seems like the result of a database upgrade from MySQL 4.0 or older to MySQL 4.1 or newer. Those must have been typographic quotes. You need to look into this: http://drupal.org/node/198184

Maybe the simplest solution is to search and replace those combinations of characters with standard latin quotes throughout the database (" and '), which are no different in UTF8. Or replace them with correct UTF8 typographic quotes. Or, of course, convert the database properly.

xjessie007’s picture

xjessie007 commented

Hi,

Thanks for the link, looks like it has the answer, but I am a bit of a newbie, so I get lost in all the information. I am having a similar problem to the one described above. When I look at my web on local, everything is ok, no problem. When I move my web to hosting, I see the "Â" throughout the text. I noticed this character replaces some spaces. See for example here: www.maxi-pedia.com. You can see it right in the first paragraph... "screen and forces you to enter". The strange thing is that this appears on only some pages. Any quick idea about quick fix, pls?

www.Maxi-Pedia.com

cog.rusty’s picture

cog.rusty commented

What is the exact MySQL version on your local and on your hosted installation?

Also, how do you enter content? (especially the content of that post) You simply type it, you use a WYSIWYG editor, you copy/paste it or import it in some way?