Share » Forums » Install & configuration » Can't install 4.0.0: UTF8 vs....

Can't install 4.0.0: UTF8 vs. iso-8859-1 sample DB problem

Can't install 4.0.0: UTF8 vs. iso-8859-1 sample DB problem

Tuesday 15 January 2008 5:26:15 am - 5 replies

Author Message

Kristof Coomans

Tuesday 15 January 2008 7:25:25 am

Hi Edward, welcome to the eZ Community!

When creating a new database for your eZ Publish installation, then specify "CHARACTER SET utf8" behind the CREATE DATABASE sql, as outlined in the documentation: http://ez.no/doc/ez_publish/technical_manual/4_0/installation/normal_installation/installing_ez_publish_on_windows or http://ez.no/doc/ez_publish/technical_manual/4_0/installation/normal_installation/installing_ez_publish_on_a_linux_unix_based_system.
Does it work now?

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Edward Bradburn

Tuesday 15 January 2008 7:41:05 am

Hi Kristof,

<b>Update</b>

Ah, OK - I understand it now!

The last step merely offers me all the MySQL DBs on my system! It would - given the root access!

I have now added a database user restricted to one DB and now I only get one DB offered on the last page.

OK - so no bug in the installer, but maybe the docs should be updated to make this fact more obvious? Plenty of people will simply opt for "root" when asked, and then will choose databases that are already in use on their system!

What do you think?

<b>end of update</b>

Thanks for the rapid reply.

I'm not sure what you mean by "creating a new database". I have simply entered the database (root account) access details on the page in the wizard - at no point have I been asked to create a database.

On the last page of the wizard the wizard asks me to choose a sample database for the ezpublish site. It seems to be *these* databases that are not in UTF8 - or I am mistaken somewhere?

I would have no problem creating a database, since I am a fairly experienced MySQL admin - but the wizard seems to want to create (or import) the databases itself. And I of course have no idea where these databases actually are!

For reference, the databases are called: "cdcol", "phpmyadmin", "test" and "webauth".

The MySQL I am running, 5.0.51, has full UTF8 support as far as I can see.

Hope this helps you resolve my query!

Many thanks,

Ed Bradburn

George H

Thursday 17 January 2008 3:56:11 pm

Click the database name and set "Collation" to UTF8-bin. : It Worked for Me

Richard Lundberg

Friday 20 August 2010 7:35:00 am

Hi, I have exactly the same problem on an 4.3 installation. I am running php 5.3 and mysql 5.1.

I have done many previous installations without problem. This is a new server because I wanted to run 5.3, but I can't complete the install because of this error.

I have checked php-myadmin and the relevant settings are listed:

MySQL connection collation: utf8_bin

MySQL charset: UTF-8 Unicode (utf8)

so I do not know why it is saying the database is created using iso-8859-1

Any help appreciated

www.peakm3.com

Doug Brethower

Friday 20 August 2010 1:55:14 pm

Have you tried specifying collation when creating the new database?

Something like:

CREATE DATABASE `ez430` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Doug Brethower
Apple Certified Technical Consultant, Southwest, MO USA
http://share.ez.no/directory/companies/lakedata.net

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu