homepage Welcome to WebmasterWorld Guest from 54.145.183.190
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
question marks after moving servers
FromBelgium

10+ Year Member



 
Msg#: 3176595 posted 11:26 am on Dec 3, 2006 (gmt 0)

After my host moved my site to another server all special caracters in data from a MySql database are shown as "?" also in phpMyAdmin. The host recommends that I manually change every "?". Is there an easier solution?

[edited by: FromBelgium at 11:26 am (utc) on Dec. 3, 2006]

 

phranque

WebmasterWorld Administrator phranque us a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



 
Msg#: 3176595 posted 12:49 pm on Dec 3, 2006 (gmt 0)

there are very specific issues regarding character sets that changed somewhere around mysql 4.0 or 4.1, so you should refer to documentation for your version, but you could start by looking at this:
[dev.mysql.com...]

this describes how the character set can be set at the server level and overridden at runtime.
you will probably need help from your host to implement this fix.
there is an entirely different and probably more complicated set of issues if you exported and imported data when moving servers especially if it was also a version upgrade.
i'm ony peripherally aware if these issues so i will defer to those more recently bruised and blistered.

FromBelgium

10+ Year Member



 
Msg#: 3176595 posted 4:49 pm on Dec 3, 2006 (gmt 0)

This is additional information:

Database:
MySQL charset: UTF-8 Unicode (utf8) (cannot be change)
MySQL connection collation:utf8_bin (can be changed)

Table:
Collation: latin_swedish_ci (can be changed)

Does this looks normal? Should I change one of the settings?
If I change the collation does this change data stored in the database?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved