Issues with character set

Tuesday 04 March 2008 6:44:41 am

Good day
I am trying to install the eZpublish 4.0.0 and the wizard keeps giving me this warning sign
under the site details page,

"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 checked out my databse and it is created ans set to [utf-8], i am using MySQL 5.0

Was reading some documentation on the unicode charset
http://ez.no/ezpublish/documentation/configuration/configuration/language_and_charset/unicode_with_ez_publish

Do i need to still set the charsets in eZ publish
just like is stated below:

Setting charsets in eZ publish

To make eZ publish handle Unicode properly you need to configure which charsets the different layers use. You will need to configure database, internal locale and default template charset. This is configured in the files:

* site.ini
* i18n.ini
* template.ini

site.ini:

[DatabaseSettings]

Charset=utf-8

i18n.ini:

[CharacterSettings]

Charset=utf-8

template.ini:

[CharsetSettings]

DefaultTemplateCharset=utf-8

That's it. You can now enjoy Unicode characters with eZ publish.

Donald.

Thursday 06 March 2008 1:07:14 am

If you have command line access to the MySQL database, the quickest way to fix this is to log in to MySQL and create your database with this one-liner before installing eZ:

create database <database_name> character set utf8