Welcome to WebmasterWorld Guest from 54.234.8.146

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Same database on different server

Different output - odd symbols

     

humpo

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

10+ Year Member



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

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

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



sounds like different charsets maybe try

CHARSET [dev.mysql.com]

that might tell you what each is set to

 

Featured Threads

Hot Threads This Week

Hot Threads This Month