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

Next topic

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:53:44
Script start
Timing:	Jan 18 2025 15:53:44
Module start 'layout'
Timing:	Jan 18 2025 15:53:44
Module start 'content'
Timing:	Jan 18 2025 15:53:44
Module end 'content'
Timing:	Jan 18 2025 15:53:44
Script end

Main resources:

Total runtime	0.8138 sec
Peak memory usage	4,096.0000 KB
Database Queries	65

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0059	589.6016	152.6563
Module start 'layout'	0.0059	0.0035	742.2578	39.5078
Module start 'content'	0.0094	0.8028	781.7656	590.3047
Module end 'content'	0.8122	0.0016	1,372.0703	12.0938
Script end	0.8138		1,384.1641

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.4324	16	0.0002
Check MTime	0.0013	0.1590	16	0.0001
Mysql Total
Database connection	0.0008	0.0954	1	0.0008
Mysqli_queries	0.7578	93.1216	65	0.0117
Looping result	0.0006	0.0792	63	0.0000
Template Total	0.7783	95.6	2	0.3891
Template load	0.0019	0.2290	2	0.0009
Template processing	0.7764	95.4009	2	0.3882
Template load and register function	0.0003	0.0318	1	0.0003
states
state_id_array	0.0013	0.1647	1	0.0013
state_identifier_array	0.0018	0.2250	2	0.0009
Override
Cache load	0.0016	0.1941	28	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0581	3	0.0002
Fetch class attribute name	0.0014	0.1714	6	0.0002
XML
Image XML parsing	0.0016	0.1954	3	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0016	6	0.0000
General
dbfile	0.0037	0.4589	17	0.0002
String conversion	0.0000	0.0011	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
7	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 19 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs