Same database on different server

Different output - odd symbols

[humpo]

Character encoding

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

Server A
PHP 4.4.0
PHP CFG same excpet '--with-mysqli' '--with-imap' '--with-imap-ssl' '--with-kerberos'
MYSQL 4.1.13

Server B
PHP 4.3.11
PHP CFG same except '--with-gettext'
MYSQL 4.0.23

thanks

[jatar_k]

sounds like different charsets maybe try

CHARSET [dev.mysql.com]

that might tell you what each is set to