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

eZ debug

Timing: Jan 19 2025 08:31:13
Script start
Timing: Jan 19 2025 08:31:13
Module start 'content'
Timing: Jan 19 2025 08:31:15
Module end 'content'
Timing: Jan 19 2025 08:31:15
Script end

Main resources:

Total runtime1.4768 sec
Peak memory usage4,096.0000 KB
Database Queries199

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0077 588.9766180.8281
Module start 'content' 0.00771.3134 769.8047591.8750
Module end 'content' 1.32100.1557 1,361.6797337.3984
Script end 1.4767  1,699.0781 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00420.2859210.0002
Check MTime0.00140.0979210.0001
Mysql Total
Database connection0.00160.111410.0016
Mysqli_queries1.392094.25931990.0070
Looping result0.00210.14271970.0000
Template Total1.443997.820.7219
Template load0.00220.152420.0011
Template processing1.441697.618020.7208
Template load and register function0.00020.014810.0002
states
state_id_array0.00090.062010.0009
state_identifier_array0.00080.051520.0004
Override
Cache load0.00190.1305440.0000
Sytem overhead
Fetch class attribute can translate value0.00140.097640.0004
Fetch class attribute name0.00140.092350.0003
XML
Image XML parsing0.00120.079940.0003
class_abstraction
Instantiating content class attribute0.00000.000950.0000
General
dbfile0.00660.4487280.0002
String conversion0.00000.000430.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
7content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
10content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 24
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs