Joomla 1.5 and MariaDb – Collation problem

We found the hard way that all Joomla 1.5 ( yes there are still joomla 1.5 )  have problem with the collation of the database when you use  UTF 8 characters . After several experiments with collation we found in some blogs that the anwer is pretty easy. You have to change a line in the mysqli file in Joomla. in  libraries/joomla/database/database/mysql.php or (depending on [...]