go to your phpmyadmin and check if those characters are turned into ??'s in the database.If those characters are converted to question marks in the database, there is not much you can do, you will need a rollback.If not you have to make sure, all your tables and sub tables are set to utf8

Checked as suggested and... rollback it is. I Ignore what could have happened while upgrading.
I'll try to install the database again. Hope this time the characters don't get scrambled.

Using CPanel and PHPMyAdmin I created a new database and imported the MySQL dump.
Although the information is correct in my computer, when uploaded it looses the accented characters. What I'm I doing wrong?

gcasanova wrote:

Using CPanel and PHPMyAdmin I created a new database and imported the MySQL dump.
Although the information is correct in my computer, when uploaded it looses the accented characters. What I'm I doing wrong?

If you are using a server bundle like wamp xamp etc. on localhost, generally everything is set to utf8, but in shared hosting environments some table collations are set to latin_swedish_5 or 1.

it's hard to pin point where you are doing wrong, however (assuming it's working on localhost) i can suggest the following:

1. Do your usual upgrade in both localhost and online.
2. Go to your phpmyadmin
3. Select your database.Drop all your tables.
4. Select your database.Go to operations and make sure collation is set to utf8.
5. Export your local sql, go online and import it.

@tilqicom
Why are you talking about local install?

Change database collation to utf-8 in properties before you import the dump.

Also make sure you select utf-8 locale during upgrade ;)

sam2kb wrote:

@tilqicom
Why are you talking about local install?

Change database collation to utf-8 in properties before you import the dump.

Also make sure you select utf-8 locale during upgrade ;)

I dont know, he says it's working on local install and not online, so i thought of a fail safe way.

Nothing is working.

tilgicom, sorry about the confution, when I mentioned my PC I meant that when checking the databases content (with notepad ++) the accents are OK. It is when exporting from an old server and importing to a new one that the accents are lost and replaced with signs (?).

I've followed your directions:

Dropped all tables
Checked collation but it is latin1_swedish_ci so I changed it to utf8_general_ci
Then imported the database but nothing is imported.

sam2kb:

Change database collation to utf-8 in properties before you import the dump.

Also make sure you select utf-8 locale during upgrade

MySQL connection collation is set to utf8_general_ci and the locale inside b2evolution is ES-Ve utf8.

I really am lost.

I think its solved (hope so): I imported the database as latin 1 and now the accented characters appear right.