WHMCS From Latin1 To UTF8

The database was in latin1 sweedish colation and this had some side effects with the Greek characters.

FIRST THING: GO TO PHPMYADMIN AND EXPORT DATABASE TO HAVE A BACKUP!

Then I went to administration, utilities, database status, download backup.

This makes a good backup with proper encoding inside. (for me this was the right version and not the one created with phpmyadmin)

I opened the .sql file with Notepad++ and I replaced latin1 with utf8 in all the document. Save.

Then I went to phpmyadmin and i checked all tables and then selected the action drop. I confirmed dropping the tables, and then I went to import.

I imported the new sql file I created with Notepad and then I checked the database structure, tables structure and browsed some of the data. Everything appeared perfect!

Loaded a sample page of WHCS but all the Greek characters were corrupted and looked like ?????. After some research I added this line in configuration.php

mysql_charset=”utf8″;

Now everything worked perfect! I checked the database again and I made sure that the database collation was utf8_general_ci (if it isn’t go to operations and change collation).

I’m a happy Greek user of WHMCS now!

Leave a Reply

Your email address will not be published. Required fields are marked *