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

warning error with database character set

Next topic

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