Quote
Ulf Dunkel
Run the script ;-)

Is it possible that this script requires Phorum 5.2.7? It won't run with 5.1.25:

Fatal error: Call to undefined function: phorum_db_interact() in /.../phorum/convert_to_utf8.php

Any hints?

SET @DATABASE_NAME = 'phorum';
SELECT CONCAT(  'ALTER TABLE `', t.`TABLE_SCHEMA` ,  '`.`', t.`TABLE_NAME` ,  '` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;' ) AS sqlcode FROM  `information_schema`.`TABLES` t WHERE t . `TABLE_COLLATION` = 'cp1251_general_ci' AND t.`TABLE_SCHEMA` =  @DATABASE_NAME ORDER BY 1 LIMIT 0 , 999;
#then execute all the queries which will be printed by this query

äöü ß àâá èêé ìîí òôó ùôú
ÄÖÜ ß ÀÂÁ ÈÊÉ ÌÎÍ ÒÔÓ ÙÛÚ

äöü ß à âá èêé ìîí òôó ùôú
ÄÖÜ ß ÀÂÁ ÈÊÉ ÌÎÍ ÒÔÓ ÙÛÚ

äöü ß àâá èêé ìîí òôó 
ùôú\r\nÄÖÜ ß ÀÂÁ ÈÊÉ ÌÎÍ ÒÔÓ ÙÛÚ

function phorum_db_mysql_connect()
{
    $PHORUM = $GLOBALS["PHORUM"];
    
    static $conn;
    
    if (empty($conn))
    {
        $conn = mysql_connect($PHORUM["DBCONFIG"]["server"], $PHORUM["DBCONFIG"]["user"], $PHORUM["DBCONFIG"]["password"], true);
        mysql_select_db($PHORUM["DBCONFIG"]["name"], $conn);
        mysql_query("SET NAMES utf8");
    }
    
    return $conn;
}