title: joomla 1.5 mariadb 10
body: <p>I have a cpanel server which I tried to upgrade the MySQL to MariaDB 10, now everything works except many Joomla 1.5 websites which were using unicode languages are now displaying question mark instead of every character:</p>
  
  <p>I have to clarify things more: The sites were displaying correctly with MySQL 5.5 before upgrade, and the data is intact in the database so when I copy the site into another MariaDB 5.6 server, it displays correctly.</p>
  
  <p>I tried :
   /etc/my.cnf.d/server.cnf</p>
  
  <pre><code>[mysqld]
  collation-server=utf8_unicode_ci
  init-connect='SET NAMES utf8'
  character-set-server=utf8
  </code></pre>
  
  <p>and /etc/my.cnf.d/mysql-clients.cnf</p>
  
  <pre><code>[mysql]
  default-character-set=utf8
  </code></pre>
  
  <p>In joomla system information I get:</p>
  
  <blockquote>
    <p>Database Collation:   N/A (mySQL &lt; 4.1.2) </p>
  </blockquote>
  
  <p>No luck</p>