We have an existing site running on EE 1.6.8.
We decided to start afresh, clean new site so we have an install of v2.7.1 running.
We’ve built the site, finished the templates and are starting to look at running imports on any old content we want from the EE 1.6.8 site.
To achieve this we’re using Solspace’s Importer and have XML feeds for the old data.
The problem is some characters are outputting odd characters such as
Harrison’s
If we check the old database table the data looks fine:
Where as the XML doesn't:
We also have an issue where some entries that have been imported end up showing some strange characters in the new templates. An example of this can be seen here:
Oddly the XML and entry appear ok for this:
The old DB 'was' Latin1 but has been changed to UTF8 and that the new DB is UTF8 and the page template (RE 2nd problem) are UTF8 also as are the XML files.
What have we missed?