Forums / Install & configuration / warning error with database character set

warning error with database character set

Author Message

donald Bart

Monday 03 March 2008 2:29:50 am

Good day,
I am trying to install the eZ publish 4.0.0, but i am stuck in the site details page, i keep getting this warning message:

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

I have check out my database character set it is not [iso-8859-1], but rather it is [utf-8], this is my MySQL charset: UTF-8 Unicode (utf8), cos i am using MySQL 5.0

I dont know what to do i have read other issues like this on the forum, and done all that is been stated but still i am stuck..

is there something i am doing wrong.

Kristof Coomans

Monday 03 March 2008 2:51:38 am

Hi Bart,

You can run the following SQL query to find out what's the default charset of your schema called db237249126:

select DEFAULT_CHARACTER_SET_NAME from information_schema.schemata where schema_name='db237249126';

Good luck!

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

donald Bart

Monday 03 March 2008 4:03:22 am

Hi krisof

Thanks for your reply..
I have just ran the query and the default charset is utf8
but i am still having the same problems, with the wizard.

Dont know what to do next...

Donald.

Albert De Queljoe

Tuesday 04 March 2008 10:42:34 am

Hello Donald,

I've got the same problem.. my MySQL charset is utf8... but still the warning message as you have mentioned in your post...

I've installed on two different servers with same result....

Is this a script issue or ? ....

regards

Ps. i'm using: MySQL 4.1.14
PHP Version: 5.2.0

EDIT: problem solved !

Click the database name and set "Collation" to utf8_unicode_ci ....

donald Bart

Tuesday 04 March 2008 11:55:02 pm

Hi Albert,
I am still stuck here with this warning about the charset ...
But i saw this write up, and dont know i guess i will have to try it out
to see if it works out

http://ez.no/ezpublish/documentation/configuration/configuration/language_and_charset/unicode_with_ez_publish

Guess to try out the configuration in this ini.
* site.ini
* i18n.ini
* template.ini

Will let you know if it works out..
But i you devise a means around it prior to me, let me know also.

Regards
Donald.

Albert De Queljoe

Wednesday 05 March 2008 1:01:01 am

Hello Donald,

Click the database name and set "Collation" to utf8_unicode_ci .. this works for me :)

Hope this will do

regards

donald Bart

Wednesday 05 March 2008 3:58:26 am

Hi Albert,

Nice to know you sorted it out..
But funny that method did not work for me,
Did change the collation setting to utf8_unicode_ci
But did not work for me...
Just dont know what next to do.

Donald

Albert De Queljoe

Wednesday 05 March 2008 7:14:26 am

Hello Donald,

Maybe you should delete the old database..make a new one and try different options in collation: - utf8_unicode_ci
- utf8_bin -----------> was reported by a member to have also solved the problem

regards

donald Bart

Wednesday 05 March 2008 8:26:31 am

Hi Albert,

Thanks for the info,
i got that sorted out...what i needed do was to
change the default character set from [latin 1] to [utf-8]
but i still am stock at the ending of the installation
it is giving me the message

The following errors were detected:

* EZSW-004Failed inserting data to mysql
Table 'ezapprove_items' already exists
* EZSW-040Failed to initialize site package 'ezwebin_site'

If you think you have fixed the errors you can try then click the "Retry" button.

still looking for a way around this

thanks.
Donald