Forums / Install & configuration / Database Problem

Database Problem

Author Message

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

Warning

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