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 :)

Please indicate if this article was helpful for you.

rating :  5.0 from 5 views :  186 votes :  1

How to change the date.timezone value in PHP?

1992

Basic security guidelines for the shared hosting server

1954

How to submit my site and optimize it for the search engines ?

1175

How do I activate SSH access for my account?

990

How to log in by FTP without pointing my domain to Siteground?

931