Problem After Restoration

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Sarao
Forum Newbie
Posts: 1
Joined: Thu Nov 27, 2008 7:07 am

Problem After Restoration

Post by Sarao »

Hi,
I have a vbulletin forum, I had some problems in the past, so I had backed up and then restored the database. But after restoration, it shows me some STRANGE characters on some posts. I have to edit and replce those. Why is it happening?
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: Problem After Restoration

Post by josh »

Character set / encoding mismatch
User avatar
Sindarin
Forum Regular
Posts: 521
Joined: Tue Sep 25, 2007 8:36 am
Location: Greece

Re: Problem After Restoration

Post by Sindarin »

I've recently being transferring a database from an old server to a new one and had the same problem because the previous web developer had not taken his time to set the db collation properly. I had to find some workarounds and convert the collation from swedish to utf8_general_ci with this tool: http://www.phoca.cz/articles/web/how-to ... -database/
Post Reply