Category Archives: Database

How to Fix the Collation and Character Set of a MySQL Database

Recently I came across with issue where migrating website from one hosting to another resulted on text encoding issues. Site was very old and lot of time had passed, so on new server all texts coming from database had cryptic signs instead of Nordic characters. All you can find below is from article on page https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html… Read More »