Forums / Install & configuration / Charset-Error in Setup-Procedure

Charset-Error in Setup-Procedure

Author Message

Stefan Huegel

Friday 24 June 2005 7:27:30 am

Hi there.

I encounter a very strange phenomenon when trying to install EZP: in the last step before closing the installation process I am given the warning ...

The database cannot be used, it uses the character set which is different from the requested charset iso-8859-1.

The database (MySQL 4.1.8a) is UTF-8, however, and charset for the database cannot be changed (=> shared webspace).

I changed the 'preferred and allowed charsets' for my German language isntallation by modifying the respective file share/locale folder - no way I can pass by that error message.

Is there any way I can teach EZP to store information in UTF-8 in my database not ISO-8859-1?

Any Feedback or help is highly appreciated. Thanx in advance!

Stefan.

Birger Kollstrand

Sunday 26 June 2005 6:53:41 am

Hi,

THere is a good article about unicode (UTF-8) support in eZ.
http://ez.no/ez_publish/documentation/configuration/configuration/language_and_charset/unicode_with_ez_publish

That solved most of my problems. There are still issues though tha I have not been able to solve. One of them is that email adresses with other characters than the ascii is not accepted as user mail addresses.

cu / birger....

Stefan Huegel

Monday 27 June 2005 2:27:12 am

Hi Birger.

First of all thanx for your reply. A had already been looking into the approach which you suggested. However it did not solve my problem.

Still I am stuck at the point where the EZP isntallation process tries to write things into the DB. Then I am given the above mentioned error message.

My DB-charset is 'latin1', collation is 'latin1_german2_ci'. As I am working with MySQL 4.1.8a there is no way I can set the charset to 'iso-8859-1'.

Anyone any idea what I am doing wrong here?

:o/

Stefan.

Birger Kollstrand

Monday 27 June 2005 11:07:12 am

Hi,

'latin1' is the same as iso-8859-1.

So if your DB is set to latin1/iso-8859-1 and you can't change it. Then all your setup of eZ should be like the default eZ setup which is iso-8859-1 if i understand the documentation correctly.

http://www.cs.tut.fi/~jkorpela/latin1/

cu / birger....

eZ debug

Timing: Jan 19 2025 04:23:33
Script start
Timing: Jan 19 2025 04:23:33
Module start 'content'
Timing: Jan 19 2025 04:23:34
Module end 'content'
Timing: Jan 19 2025 04:23:34
Script end

Main resources:

Total runtime0.8913 sec
Peak memory usage4,096.0000 KB
Database Queries197

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0074 589.0781180.8203
Module start 'content' 0.00740.7364 769.8984484.1406
Module end 'content' 0.74380.1475 1,254.0391333.4766
Script end 0.8913  1,587.5156 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00410.4622210.0002
Check MTime0.00140.1591210.0001
Mysql Total
Database connection0.00100.111410.0010
Mysqli_queries0.828892.98451970.0042
Looping result0.00210.23071950.0000
Template Total0.863296.820.4316
Template load0.00200.228320.0010
Template processing0.861196.613020.4306
Template load and register function0.00010.015510.0001
states
state_id_array0.00110.122510.0011
state_identifier_array0.00120.135320.0006
Override
Cache load0.00170.1947310.0001
Sytem overhead
Fetch class attribute can translate value0.00140.153030.0005
Fetch class attribute name0.00100.117740.0003
XML
Image XML parsing0.00050.057830.0002
class_abstraction
Instantiating content class attribute0.00000.001240.0000
General
dbfile0.00210.2308210.0001
String conversion0.00000.000630.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
6content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 14
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs