Forums / Install & configuration / Issues with character set

Issues with character set

Author Message

donald Bart

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.

Piotrek Karaƛ

Wednesday 05 March 2008 10:51:42 pm

Check the database's default collation setting - it has to be set to one of the utf's, for example utf8_general_ci (but not unicode as far as I know).

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Michael Hall

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

donald Bart

Friday 07 March 2008 8:08:14 am

Hi guys

Thanks a million for all the info
I got it all sorted out, it was the issues
of my default character set and collation not been
same at the creation of the database.

Thanks.
Donald