How to Eemove  Character

[thusband]

I recently moved my site to a FutureQuest server that supports MySQL5 so I could upgrade to Wordpress 2.9. Now at the end of just about every sentence I there's a  character. Does that have to do with MySQL5 or Wordpress 2.9? How do I get rid of them? I hope manually deleting them isn't answer.

Thanks for any help,

Tom Husband
http://california-travels.com/

[Jeff]

Is it a latin1/UTF-8 Charset issue? http://aota.net/forums/showthread.php?postid=171468#post171468

[sheila]

Tom, we are investigating this issue and will get back to you about it after we've had a chance to review this with our resident expert on MySQL and character encodings. This is basically related to how MySQL stores character codes in the database.

[Arthur]

Tom, as mentioned this is a latin1 to utf8 conversion problem. You can replace strings in MySQL with the REPLACE command, which allows you to replace characters or words.

However, the  wasn't the only problem. Because the database had been changed since the upgrade, fixing the problem was made much more difficult, but we managed to scrub the weird characters from your Wordpress posts. Should you still have problems, please send us an email with some examples of posts that are not correct.

-Arthur