Forums / Install & configuration / character set problem (UTF-8, greek)

character set problem (UTF-8, greek)

Author Message

Oliver Dahlmann

Monday 14 June 2004 3:26:28 am

I’m trying to set up a multilingual website with ezPublish 3.4, containing content in english, german and greek language on an Server running Mandrake 10.0 official Linux.

The Problem is that I only get ρϛ and so on on the browser-screen. I know that some guys had the same problem before, but all of the tips and tricks out of the forum and the ezPublish-documentation didn’t help me.

This is what I have done: Because of the greek language I decided to use UTF-8 charset.

I did the following things:

- I downloaded MySQL 4.1.2-alpha-standard for UTF-8 Support. I created the database with UTF-8 Support (create database bla character set utf8;). Seems to work fine.
- I downloaded the ‘php-mbstring-4.3.4-1mdk.i586.rpm’ and installed it. I also changed the default character set in /etc/php.ini.
- I edited the i18n.ini, the site.ini and the override.ini and set the character set from iso-8859-1 to utf-8.
- I created some additional directories under settings/siteaccess called website_de, website_en and website_el (for the greek language).
- I have made a ‘translation.ts’-file and moved it to share/translations/ell-EL, I also created a file named ell-EL.ini with the lines:

[RegionalSettings]
Country=Greece
LanguageName=Greek
InternationalLanguageName=Greek (Greece)

[Charset]
Preferred=iso-8859-15 # I also tried utf8 and utf-8

[HTTP]
ContentLanguage=ell-EL

# Rest of the file like the English version

If I watch the website website_el in my browser, ezPublish delivers the right (greek) translated content, but is not able to show the Cyrillic charset. Where the browser should get a ρ for example, it gets a ρ which will printed on the screen like &#961.

If I look into the sourcecode of the generated webside, I see the line
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

Has somebody an Idea what I&#8217;m doing wrong?

Thank you very much,

Oliver

Björn Dieding@xrow.de

Monday 14 June 2004 5:40:08 am

Please double check the following...

site.ini <- db charset set to utf8

check the admin area <- does it have settings for uft8 too?

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

eZ debug

Timing: Jan 31 2025 06:23:26
Script start
Timing: Jan 31 2025 06:23:26
Module start 'content'
Timing: Jan 31 2025 06:23:26
Module end 'content'
Timing: Jan 31 2025 06:23:26
Script end

Main resources:

Total runtime0.1929 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0067 588.0547180.8203
Module start 'content' 0.00670.0063 768.875093.9297
Module end 'content' 0.01300.1798 862.8047525.3281
Script end 0.1928  1,388.1328 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00341.7856200.0002
Check MTime0.00140.7382200.0001
Mysql Total
Database connection0.00080.402210.0008
Mysqli_queries0.139572.29001410.0010
Looping result0.00120.62011390.0000
Template Total0.179392.910.1793
Template load0.00100.540610.0010
Template processing0.178392.390810.1783
Override
Cache load0.00060.330210.0006
Sytem overhead
Fetch class attribute can translate value0.00150.766610.0015
XML
Image XML parsing0.00030.132210.0003
General
dbfile0.01085.6102200.0005
String conversion0.00000.004230.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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs