Support

Pre-sales

#21535 Wrong Character Set

Posted in ‘Pre-sales and Account Questions’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by optimized on Tuesday, 25 November 2014 10:28 CST

optimized
 Hi,

I have used Akeebla Backup Wordpress to move http://gramafina.com/ to http://disenopaginaswebpanama.com/grama and, as you can see, the character set has changed and my Spanish characters do not show correctly.

What could have caused this issue?

Thanks,

Mike

nicholas
Akeeba Staff
Manager
Hello Mike,

When restoring the backup archive there are two options in the Site Setup page called Database Charset and Database Collation. Try setting the Database Charset option to
utf8
and leave the Database Collation empty.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

optimized
Do you mean the Configuration page?

Thanks,

Mike

nicholas
Akeeba Staff
Manager
No. I mean when restoring the backup. The second to last page in the ANGIE installer script is Site Setup. In there you'll see two fields called Database Charset and Database Collation. Try setting the Database Charset option to
utf8
and leave the Database Collation empty.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

optimized
tick UTF-8 collation force in the database and
Force UTF-8 collation tables ?

Mike

nicholas
Akeeba Staff
Manager
No. This page here: https://www.akeebabackup.com/documentation/solo/angie-wordpress-setup.html

Database charset. Set it to utf8
Database collation. Leave it blank.

This is the page shown AFTER the database restoration page you are talking about.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

optimized
You guys are the best!

Thanks very much

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!