02 April 2014, 7:52

Hello,

I'm trying to install Mahara on my personal server space, purchased from a company. I've fixed a number of problems so far, but now, I'm stuck with this one:

"You are not using a UTF-8 database. Mahara stores all data as UTF-8 internally. Please drop and re-create your database using UTF-8 encoding."

The administrator is suggesting I use a program to recode the dump of the database (can't post the link here).

I'm not a network guru, or a programmer. I'm a teacher of English. Is there a simpler way to fix this problem? 

Many thanks!

Irshat

02 April 2014, 11:28

Hi Irshat,

It sounds like you're using a "shared hosting" environment, where you don't actually have full control of everything, and you create and manage databases through some kind of web-based control panel? And you're using MySQL? If that's the case, try running this SQL command in the "SQL" pane of your phpMyAdmin:

ALTER DATABASE yourdatabasenamegoeshere CHARACTER SET utf8;

Cheers,

Aaron