Forums / Developer / Is it possible to run a Mutli-lingual site without using UTF-8?
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.htmlI 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
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?
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
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?