mdp8593I just imported several entries from a Typepad blog into a WP 2.1.2 blog, and I now have several question marks (?) throughout all the posts. The question marks have replaced characters such quotation marks ("), apostrophes (') or ellipsises (...).
I went into the DB through phpMyAdmin and took a peek at the post_content field. Here's an example of a paragraph from one of the entries:
This is how it reads within the database field:
<p>� Flora was to make the journey to Skye, accompanied by �one Bettie Burke, an Irish girl, who, she tells me, is a good spinster�. The prince and Flora set sail from Benbecula to Skye on the night of 28-9 June 1745 in a small boat crewed mainly by militiamen. Many tales were told afterwards about the escape, but Flora's favourite was the one in which she said she forbade Charles to carry his pistols under the petticoat of his dress, telling him that, if searched, they would give him away. �If we shall happen to meet with any that will go so narrowly to work in searching as what you mean, they will certainly discover me at any rate�, the prince replied.</p>
Here's how it SHOULD read on the site:
… Flora was to make the journey to Skye, accompanied by ‘one Bettie Burke, an Irish girl, who, she tells me, is a good spinster’. The prince and Flora set sail from Benbecula to Skye on the night of 28–9 June 1745 in a small boat crewed mainly by militiamen. Many tales were told afterwards about the escape, but Flora's favourite was the one in which she said she forbade Charles to carry his pistols under the petticoat of his dress, telling him that, if searched, they would give him away. ‘If we shall happen to meet with any that will go so narrowly to work in searching as what you mean, they will certainly discover me at any rate’, the prince replied.
Here's how it DOES read on the site:
� Flora was to make the journey to Skye, accompanied by �one Bettie Burke, an Irish girl, who, she tells me, is a good spinster�. The prince and Flora set sail from Benbecula to Skye on the night of 28-9 June 1745 in a small boat crewed mainly by militiamen. Many tales were told afterwards about the escape, but Flora’s favourite was the one in which she said she forbade Charles to carry his pistols under the petticoat of his dress, telling him that, if searched, they would give him away. �If we shall happen to meet with any that will go so narrowly to work in searching as what you mean, they will certainly discover me at any rate�, the prince replied.
The database charset is UTF-8 Unicode (utf8), and the collation on all the tables is latin1_swedish_ci (as set by the standard WP 2.1.2 install).
So, any ideas why this happened, how to fix it, and how to avoid it in the future?
Thanks - Michael
