How to save an .sql file with UTF-8 encoding?

When you backup your database, it is not always saved with UTF-8 collation. This is a problem if you have some special characters because after a database restore they won't be displayed properly unless the database is with UTF-8 collation.

The easiest solution is, once you dump the database, to open the sql file with Notepad, click on File > Save As and choose UTF-8 next to Encoding. Save the new file. Now you will have a dump of your database with UTF-8 collation 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Brute Force Attack – What it is and How to Block It

Brute-force is a method of guessing your password by trying combinations of letters, numbers and...

What is pdftoppm and is it supported by Hostlantern?

Pdftoppm is a library that handles the conversion from Portable Document Format (PDF) files to...

How to clear your Internet browser’s cookies?

Sometimes you may need to clear the cookies saved by your browser. Basically the cookies...

Hacked Website

The most common reasons for a hacked (defaced) website include: - Outdated web application....

How to clean my files from malicious code?

If your website has been hacked and malicious content has been inserted into your files, you...