-
☆ A M B ☆
- 24,524 Posts
Well, in the first place I would suggest never using any charset except utf-8. It has been my experience that anything else will have intermittent encoding problems. That means in the database as well.
When the site was moved from a local server to a hosted server, presumably the DB was exported and imported as well. Hopefully this issue came about at that stage, which would make sense because that’s a point at which the data is being saved to a text file and then loaded again. This would mean that the export/import can be repeated correctly to fix the problem.
An essy way to confirm that this is the case would be to browse the data in phpMyAdmin both locally and remotely to compare them.
If this is the issue, how was this import/export done in this case? Was it with MODx’s export facility or phpMyAdmin or what?
Even though this doesn’t affect me, I’d like to know the best practice so we can add it to an FAQ.