Support

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 2.5.6
PHP version: server uses 5.3.2 and localhost uses 5.4.4
MySQL version: 5.1.63 on servers and 5.5.25 at localhost
Host: Locaweb
Akeeba Backup version: 3.6.3
Links to logs:
Frontend log: www.tutorbrasil.com.br/frontend_log.txt
Backend log: www.tutorbrasil.com.br/backend_log.txt

Description of my issue:

I use the option of multiple databases backup to save a backup from my phpBB forum as well.

The informations I think relevant to the situation are:

In my host:
Character set: utf8
database collation: utf8_general_ci
tables collation: latin1_general_ci for someones and utf8_bin for others (but the problem is in a table with latin1_general_ci

localhost using MAMP 2.1.1

In order to restore the database to my localhost, I first create the databases using utf8_general_ci collation (as described in some ticket I've read in akeeba forum, but already tried to use latin1_general_ci as well).
When restoring, I've checked the option "Force UTF8 collation" and already tried without this option checked as well.

After restoring, all the tables in my localhost have the exactly same collation as the server.
But, when a word has a letter with accent, it breaks the word in that letter.
Example, the word:

"matemática"

is show as

"matem"

Is there some configuration that I am missing?

Kind regards,
Thyago

Hello Nicholas,

Thanks for your reply.

After your comment, I've changed the collation of all tables that were latin1_general_ci to utf8_general_ci using the command

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

So, now my database has some tables with utf8_bin and the rest is utf8_general_ci.

And the behavior is still the same, the accent is still breaking the words.

Another try?

Kind regards,
Thyago

So, no solution??????

Hello Nicholas,

I've downloaded the .jpa file form my server (200Mb) using my FileZilla FTP Client with binary transfer type configured.

In my desktop, I've extracted the .jpa file using Akeeba eXtract Wizard 3.3.

The phpbb DB has files from .sql to .s324.

Searching for the tables with errors, I opened the 28DE3B39-phpbb.s298 using TextWrangler editor and could see that the word "Matemática" appears as "Matem·tica".

And all the other words with accent are being show with strange characters instead of the áéíóúãõà...