0
There was a database on an A server. I deleted that server and am creating a new B server.
When importing the.sql file to the B server, the names are all wrong.
Imagery:
How do I make in the database what has accent appear its due accent?
At the beginning of SQL has this:
/*!40101 SET NAMES utf8mb4 */;
In the creation of tables this way:
ENGINE=InnoDB DEFAULT CHARSET=latin1;
Thank you.
It’s coding problem, see the answers in this other question to understand what you need to set up.
– Woss
@Is Andersoncarloswoss possible to fix this in the database import? In my SQL file you have this comment
/*!40101 SET NAMES utf8mb4 */;– Tiago
@Andersoncarloswoss In the creation of the tables this so:
ENGINE=InnoDB DEFAULT CHARSET=latin1;– Tiago