Forums / Install & configuration / eZ publish 4.0 MySQL utf8 install problem

eZ publish 4.0 MySQL utf8 install problem

Author Message

Michael Hall

Monday 24 December 2007 11:15:35 pm

Gday:

I'm trying to install eZ publish 4.0 on the following platform:

openSUSE 10.3
apache 2.2.4 (prefork)
PHP 5.2.4
MySQL 5.0.45

I'm using the wizard which is complaining about the database as follows:

Warning

The database [dbez4] 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 [dbez4] .

I have fiddled just about everything I can think of in MySQL, and have done all the usual 'SET NAMES' and 'SET CHARACTER SET' stuff. All the character_set_* variables are now utf8, even in the /etc/my.conf file, but I still get the same error message.

I actually started with a manual install and got a site up OK, but it was bare bones and I wanted a 'kick start' so have now opted for the wizard. Have I overlooked something? Could the problem lie in the site packages (plainsite / ezwebin) I'm trying to use, or maybe in PHP?

Confused ... any tips?

Greg McAvoy-Jensen

Monday 24 December 2007 11:27:56 pm

Michael,

Welcome to eZ Publish. Which character were you hoping to use? If UTF8, when you created the database, did you use:

mysql> create database <database> character set 'utf8';?

Granite Horizon, Certified Developer of eZ Publish Web Solutions
Provider of the SaaS Solution Granite Horizon In The Cloud | http://granitehorizon.com/cloud
http://granitehorizon.com | +1 916 647 6350 | California USA | @granitegreg
Blog: http://granitehorizon.com/blog

Michael Hall

Monday 24 December 2007 11:41:47 pm

That works perfectly, thanks!