Forums / Install & configuration / Database Problem
Christian Santiago
Monday 03 May 2010 2:27:16 pm
Hello,ive installed the latest ez publish with ez flow on my site,i went through the steps and everything went ok,untill i got to 71% where i have to put the details for the site,and when i hite next i get this error
The database [db328220869] 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 [db328220869]
now i went to phpmyadmin and the database was created in utf-8 thats what it says,so how can i fix this.i have 1and1 hosting and i have no idea how to change thsi database to utf-8 if i have to.thanks in advanced
Jarosław Heba
Monday 03 May 2010 3:18:27 pm
Hi,
What about collation?
Doug Brethower
Monday 03 May 2010 9:06:28 pm
In phpmyadmin or in mysql prompt:
ALTER DATABASE `db328220869` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Cheers!
Doug Brethower Apple Certified Technical Consultant, Southwest, MO USA http://share.ez.no/directory/companies/lakedata.net