Forums / Developer / Is it possible to run a Mutli-lingual site without using UTF-8?

Is it possible to run a Mutli-lingual site without using UTF-8?

Author Message

Brendan Pike

Saturday 18 October 2003 6:16:09 am

I wish to run a site in english and russian and don't really wish to upgrade to mysql 4.1. I have enabled Russian for testing and have found that text within the body areas works and translates correclty as do my folder names (which I use for menus) but I found that info-page titles don't and rather appear as "Ко.." etc, even though the body works. Also the language .ts file doesn't work and only gets rendered as question marks unless I switch UTF-8 on; but doing this causes the Online Editor to not load.

Can anyone explain if it is possible without moving to postgresql or
mysql4.1?

Thanks

www.dbinformatics.com.au

We are always interested in hearing from experienced eZ PHP programmers and eZ template designers interested in contract work.

Jan Borsodi

Wednesday 22 October 2003 5:47:29 am

It is possible to run multiple languages on one database without using UTF-8, however to do so you need to use a charset that supports all languages.
As for your site which needs english and russian you can use the koi8-r charset, it contains bother (basic) latin and cyrillic characters.

The unicode characters 1050 and 1086 can be found on this page:
http://www.alanwood.net/unicode/cyrillic.html
I also looked in the share/codepages/ko8-r file and the characters are present there (in hex).

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

Brendan Pike

Sunday 09 November 2003 7:07:59 pm

Thanks Jan, only just found this response. (the forums should auto notify the authour of a forums thread IMHO)

I actually moved to MySQL 4.1 as I thought I had no other choice. So going through a little pain with upgrading our 2.2 sites at the moment. I have noticed that the share/codepages/utf-8 file is missing in the 3.2-3 release though. Does one exist I can download somewhere?

www.dbinformatics.com.au

We are always interested in hearing from experienced eZ PHP programmers and eZ template designers interested in contract work.

andreas spahr

Monday 17 November 2003 7:49:55 am

Online Editor and UTF-8, it works:
The Online Editor did not load, because the JavaScript file ezeditor.js is not an unicode file.
You have to save the file extension/ezdhtml/design/standard/javascripts/ezdhtml/ezeditor.js
with the normal windows editor as an utf-8 file (doing so with File->Save As->Coding: select utf-8)

After that I uploaded this file to the linux system via ftp and it worked!

Regards

Brendan Pike

Monday 17 November 2003 6:35:25 pm

At first I was confused what you meant by windows editor, then I realised even notepad was sufficient. You were correct of course and now it works fine!

Thanks so much Andreas.

btw, I still get the error, share/codepages/utf-8 is missing but it doesn't seem to stop anything working?

www.dbinformatics.com.au

We are always interested in hearing from experienced eZ PHP programmers and eZ template designers interested in contract work.

eZ debug

Timing: Jan 18 2025 15:05:36
Script start
Timing: Jan 18 2025 15:05:36
Module start 'content'
Timing: Jan 18 2025 15:05:36
Module end 'content'
Timing: Jan 18 2025 15:05:36
Script end

Main resources:

Total runtime0.1421 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.0074 587.9688180.7969
Module start 'content' 0.00750.0053 768.765697.9766
Module end 'content' 0.01270.1293 866.7422526.6719
Script end 0.1420  1,393.4141 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00352.4414200.0002
Check MTime0.00130.9283200.0001
Mysql Total
Database connection0.00070.494810.0007
Mysqli_queries0.092264.88421410.0007
Looping result0.00120.84961390.0000
Template Total0.129090.810.1290
Template load0.00956.678710.0095
Template processing0.119584.100710.1195
Override
Cache load0.00050.347610.0005
Sytem overhead
Fetch class attribute can translate value0.00090.600110.0009
XML
Image XML parsing0.00040.251310.0004
General
dbfile0.00281.9457200.0001
String conversion0.00000.005730.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.0001 secs