[ntldr1962]

Ready! we solved it thank you!

at the end we used a php script to convert the Database, and also "DONT FORGET" to put in languages in the Admincp "utf8" not UTF-8

here is my simple script:

<?php


// Fill in your configuration below
$db_server = 'server';
$db_user = 'user';
$db_password = 'pass';
$db_name = 'db';
$char_set = 'utf8';



header('Content-type: text/plain');

$connection = mysql_connect($db_server, $db_user, $db_password) or die(mysql_error() );

$db = mysql_select_db($db_name) or die( mysql_error() );

$sql = 'SHOW TABLES'; $result = mysql_query($sql) or die( mysql_error() );

while ( $row = mysql_fetch_row($result) )
{
$table = mysql_real_escape_string($row[0]);
$sql = "ALTER TABLE $table DEFAULT CHARACTER SET $char_set COLLATE utf8_unicode_ci";
mysql_query($sql) or die( mysql_error() );

print "$table changed successfully.\n";
}


// Update the Collation of the database itself
$sql = "ALTER DATABASE CHARACTER SET $char_set;";
mysql_query($sql) or die( mysql_error());

print "Database collation has been updated successfully.\n";

// close the connection to the database
mysql_close($connection);

?>