Either set utf8 as default charset for databases in mysql conf or create the database in utf8:
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_bin
This is a very common problem. I think explanation and solution should be offered by wizard, not a cryptic error message.
EDIT: skimmed over your question too quickly, i see now that maybe your hosting doesnt permit remaking database.. but generally making it as above should be solution.
Certified eZ developer looking for projects.
zurgutt at gg.ee
Thank you.
I resolved a problem... only to find another one on my way. I change the db through a php script. This one:
mysql_connect($SERVER,$USER,$PASSWORD);
mysql_selectdb($DATABASE);
$QUERY = mysql_query("ALTER DATABASE $DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
Now phpmyadmin say that the charset and collation are correct but the warning still remain.
I think that the problem is in the words: "<i>the database has been created using character set [iso-8859-1]</i>". How can I change a db, even with php language, with correct rights?
Other info.
I try with ez 3.8 and it doesn't work so I think it's a problem of server configuration or setting. I don't have enogh permission to change or even read them so...
You must be logged in to post messages in this topic!
