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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 19 2025 10:43:45
Script start
Timing: Jan 19 2025 10:43:45
Module start 'layout'
Timing: Jan 19 2025 10:43:45
Module start 'content'
Timing: Jan 19 2025 10:43:45
Module end 'content'
Timing: Jan 19 2025 10:43:45
Script end

Main resources:

Total runtime0.0243 sec
Peak memory usage2,048.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0148 589.2578152.6250
Module start 'layout' 0.01480.0026 741.882839.4453
Module start 'content' 0.01740.0048 781.328193.3516
Module end 'content' 0.02220.0020 874.679734.3047
Script end 0.0243  908.9844 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002510.4188140.0002
Check MTime0.00124.8049140.0001
Mysql Total
Database connection0.00104.035210.0010
Mysqli_queries0.011045.277630.0037
Looping result0.00000.056910.0000
Template Total0.00166.510.0016
Template load0.00093.619910.0009
Template processing0.00072.882610.0007
Override
Cache load0.00062.364210.0006
General
dbfile0.00020.947480.0000
String conversion0.00000.037340.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs