16 April 2014, 19:47

Hi,

I try to install mahara 1.9 on a shared hosting (OVH). On this hosting, i have a mysql database which is configured in utf8_unicode_ci. I can't modify this parameter as it is a shared hosting. When i try to install mahara 1.9, i get this erreor message :

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.

Anybody knows a workaround t othis problem ?

Thanks in advance for your answers

Philippe

20 April 2014, 17:04

Hi Philippe,

When I create a mysql database I use this command:

CREATE DATABASE `mydatabasename` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;

So does the database you connect to have the character set  = utf8?

If not, and your database is empty, you can try running this command:

ALTER DATABASE mydatabasename CHARSET = utf8;

Hope this helps

Cheers

Robert

05 January 2016, 6:01

I have just installed the latest version of Mahara and get the error message 

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.

but I have checked and the database is using 

• Server charset: UTF-8 Unicode (utf8)

Is there anything else I can check?

David