Backup restore charset trouble

[Anne]

Charsets must have a reason, but I only bump into them when I'm in trouble .

I make a back up one DA server and restore it on a new DA server.

Than characters like é and ë shows up like: �

A tipical charset problem I believe, but I dont know how to fix this. Should I modify something on the backup server or on the restore server?

Old server: MySQL 5.1
New server: MySQL 5.6

I hope someone can point me in the right directing of the best approach to fix this.

 

[Anne]

Update:
What I did so far BTW was change the Database Coalition to UTF8_bin. Also the columns in the tables.
Than backup and restore again, but this has no effect.

 

[Anne]

update:

Old server DB settings:

character set client: utf8
Global value: latin1


New server DB settings:

character set client: latin1
Global value: utf8mb4

This is the problem? Any idea how I should change this and on which server?

 

[zEitEr]

Hello,

We had a similar issue when switched some servers from mysql/mysqli to mysqlnd.
How does your /etc/my.cnf look like?

 

[Anne]

Thanks for your reply.

It turned out that switching it all to UTF8, everything works like it should. Also DB don't have to convert to UTF8, but can be latin, since this charset is already present in UTF8 as I was told. Learned a little bit about charsets after all .

Config is now:

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
local-infile=0
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8