Have uploaded the same database to two different hosts.
Created a simple function to retrieve and output the content in html
On server A the content looks fine, but on server B the content has odd character symbols instead of apostrophes.
Both machines are using linux, MYSQL, and php
Tied few things and still non the wiser, have included any info i think might help.
On server A, using phpMyAdmin i can see ‘content’ field has the collation of latin1_swedish_ci
On server B, i can’t see what the collation is but know the default for the server is latin1
PHP CFG same excpet '--with-mysqli' '--with-imap' '--with-imap-ssl' '--with-kerberos'
PHP CFG same except '--with-gettext'