Getting strange characters on webpage after import to new database

user_5878961 0
Viewed 29

I have an old site, and i'm trying to import it to another database. Although whenever I import it on the new database, i'm getting strange characters.

enter image description here

Which should be:

enter image description here

Both databases and all the tables are the same type (utf-8-general-ci)

In the header of the site I have the following meta tag:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

I have also tried multiple database applications (adminer, phpmyadmin and navicat) which are all exporting them as utf-8

Who can help me with this issue

mariadb webserver html
1 Answers

Well since you have the correct collation then here is your problem:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

Should be

<meta http-equiv="Content-Type" content="text/html">
<meta charset="utf-8">
user_150513100
Related