mysql_full_unicode_support#File_format

mysql_full_unicode_support#File_format

by Vinothkumar R -
Number of replies: 1

Hi Friends,

I have database MariaDB with 10.0.34 and all my previous databases are used Antelope format. 

Now I am trying to install 3.5 Moodle version, it requires Barracuda file format.

Checking with documentation is have steps for setting Global.

How can I change File_format and unicode for a particular database?

Thanks,

Vinoth

Average of ratings: -
In reply to Vinothkumar R

Re: mysql_full_unicode_support#File_format

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
You can't. You need to drop it and recreate it as...

create database moodle default character set utf8mb4 collate utf8mb4_unicode_ci;

Barracuda is not actually *required* but it's a bit tricky to persuade Moodle.