Knowledge Base Article

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



Rating

Please indicate if this article was helpful for you.

rating :  4.3 from 5
views :  4732
votes :  19

Related Articles

Views

Haven't found what you are looking for? Suggest an article HERE.

powered by

Valid XHTML 1.0 Strict Valid CSS!