Installation problem with charater set of the db

Wednesday 10 January 2007 3:01:47 am

Hi to you all.
I recently download the latest installation of eZ 3.9. I didn't find the packages for this version so I use the 3.8 ones.Then I activated a hosted domain space on a Linux server but I have a problem.
During installation I receive this message:

"Warning
The database [heroneti47858] cannot be used, the setup wizard wants to create the site in [utf-8] but the database has been created using character set [iso-8859-1]. You will have to choose a database having support for [utf-8] or modify [heroneti47858] ."

I read other posts where users resolve the probleme simply changing the character and collation set, but I have a problem too.
I'm on a hosting server so don't have a direct control on the server configuration file.
I can use a simply, web based phpmyadmin form where I can read that my char set is: UTF-8 Unicode (utf), and the collation is: utf8_general_ci.

My doubt are:

1)why eZ ask me a "database having support for [utf-8]" if I have a utf-8 database?
2)can I choose another compatible collation? (I set Italian language by default)?
or
3) How can I resolve the problem?

Thanks.

Christian

Wednesday 10 January 2007 10:38:34 pm

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?

Friday 12 January 2007 4:45:35 am

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...