Forums / Install & configuration / Exponential 4.0 MySQL utf8 install problem

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Exponential 4.0 MySQL utf8 install problem

Previous topic

Install & configuration

Next topic

Author	Message
Michael Hall	Monday 24 December 2007 11:15:35 pm Gday: I'm trying to install Exponential 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 Exponential. 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!

Author

Message

Michael Hall

Monday 24 December 2007 11:15:35 pm

Gday:

I'm trying to install Exponential 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 Exponential. 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!