0

I'm migrating a Moodle server in Spanish. I need use tick marks. I have export and import database.

mysqldump --default-character-set=utf8mb4 -u root -p moodle > moodle.sql

mysql -u root -p --default-character-set=utf8mb4 moodle < C:\Temp\moodle.sql

When I open the .sql file on notepad++, it is in UTF16 (Unicode). I changed it to UTF8 and saved the file. But when I import and launch, a query words with tick marks appears with errors.

How can I be sure that my file is encoded in UTF8?

Improve this question
1
  • 1
    The database needs to be configured for UTF-8. Most databases did not have UTF-8 support until a few years ago. See the following for the DML commands to alter the database: stackoverflow.com/a/202246/175990 Commented Dec 23, 2024 at 12:56

0

Reset to default

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.