Forums / Install & configuration / Installation problem with charater set of the db

Installation problem with charater set of the db

Next topic

Author	Message
christian bencivenni	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
zurgutt -	Wednesday 10 January 2007 8:43:08 am Hi 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
christian bencivenni	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?
christian bencivenni	Wednesday 10 January 2007 11:29:42 pm I also try with: mysql_connect($SERVER,$USER,$PASSWORD); mysql_selectdb($DATABASE); $QUERY = mysql_query("ALTER DATABASE $DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_bin"); but without success. No one can help me? Can it be a 3.9 installation problem?
christian bencivenni	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...