Welcome to WebmasterWorld Guest from 54.197.72.5

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Same database on different server

Different output - odd symbols

     
3:42 pm on Oct 28, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 18, 2003
posts:58
votes: 0


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

3:31 pm on Oct 31, 2005 (gmt 0)

Administrator

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 24, 2001
posts:15755
votes: 0


sounds like different charsets maybe try

CHARSET [dev.mysql.com]

that might tell you what each is set to