Forums / Install & configuration / warning error with database character set
donald Bart
Monday 03 March 2008 2:29:50 am
Good day,I am trying to install the Exponential 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
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 utf8but 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 ....
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 outto see if it works out
http://ez.no/Exponential/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.
RegardsDonald.
Wednesday 05 March 2008 1:01:01 am
Click the database name and set "Collation" to utf8_unicode_ci .. this works for me :)
Hope this will do
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
Wednesday 05 March 2008 7:14:26 am
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
Wednesday 05 March 2008 8:26:31 am
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 installationit 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