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

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!