PDA

View Full Version : No foreign symbols after server switch.


northwallace
01-11-2012, 04:11 PM
Really confused at what I need to do. utf-8 with language 'character set' as utf-8.

Everything worked fine until server switch.

Any advice would be greatly helpful... I'm stumped (and having a panic attack) and my users are now forced to see a black box with a question mark in it instead of foreign characters.

Please, any ideas?

Thanks

Disasterpiece
01-11-2012, 04:33 PM
what did you set exactly as utf-8? Your database tables? Your site? vBulletin Settings?

northwallace
01-11-2012, 04:46 PM
i didn't change anything after the move. That's just the database encoding, and the language parameter in vbulletin setting... thought that would help.

I'm guessing the new database doesn't have the same encoding as the last one. I don't know why this would be. I also don't know how in the world to change that..

Disasterpiece
01-11-2012, 05:01 PM
If you're using phpmyadmin, there's an option to change the collation for individual tables and fields.

I only have the newest pma version right now, but it should look something like this:

northwallace
01-11-2012, 05:02 PM
What would I switch it to?

Disasterpiece
01-11-2012, 06:25 PM
utf8_general_ci or utf8_bin

Lynne
01-11-2012, 08:38 PM
You need to make sure that your new database is using the same collation and charset as your old database.

northwallace
01-11-2012, 09:00 PM
Finally found it out.

Used this guide https://www.vbulletin.com/forum/showthread.php/259250-Language-Charset-Problems-Things-To-Check

It was actually un-commenting the line within config.php thus manually setting the default connection for utf-8.

Thanks for everyone's help.