title: MySQL full Unicode support issue : Variable 'innodb_file_format' is a read only variable ( MOODLE 3.10.1 Installation)
body: <p>I want to install MOODLE 3.10.1 in the local server (xampp windows 10 pc) for my own learning. According to the installation guide I need to Compile the following</p>
  <p>&quot;Your database uses Antelope as the file format. Full UTF-8 support in MySQL and MariaDB requires the Barracuda file format. Please switch to the Barracuda file format. See the documentation MySQL full Unicode support for details.&quot;</p>
  <p>According to the moodle installation guide (<a href="https://docs.moodle.org/310/en/MySQL_full_unicode_support" rel="nofollow noreferrer">https://docs.moodle.org/310/en/MySQL_full_unicode_support</a>), I ran the following SQL command and I am getting the following error.</p>
  <blockquote>
  <p>#1238 - Variable 'innodb_file_format' is a read only variable</p>
  </blockquote>
  <p>Other details of PHP MYADMIN</p>
  <ul>
  <li>PHP Version 7.3.26</li>
  <li>System Windows NT DESKTOP-LTTS1D7 10.0 build 18363    Windows 10) AMD64</li>
  <li>Build Date   Jan 5 2021 15:04:15</li>
  <li>Compiler MSVC15(Visual C++ 2017)</li>
  </ul>
  <p><a href="https://i.stack.imgur.com/repZF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/repZF.png" alt="Moodle installtion guide picture" /></a>
  <a href="https://i.stack.imgur.com/VD8gQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VD8gQ.png" alt="Screen shot of error code appearing " /></a>
  <a href="https://i.stack.imgur.com/HxA3H.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HxA3H.png" alt="XAMPP server image" /></a></p>
  <p>I already tried uninstalling and reinstalling but it does not work. In PHP 7.1 version this problem doesn't occur but moodle installation required  PHP 7.2 or above.</p>
  <p>Thank you in advance.</p>