Hi
Your problem has two sides: 1. database side * you can use mySQL or postgreSQL (more flexible, it is my point of view ) ) with utf8 (for europena language, not assian it is more than enough) * build a language table (usefull if you wish to add in future other language) * every single other tables which contain text/link/name which need to be stored in more language should be linked (secKey) by language table. Do not create multiple fields for each language. Each content should be on 2 rows in your case, one for En and one for Fr. 2. application side * you can use JavaScript / Jscript (client side) * create a class (my_lng.class) in php or asp for example and any time, in a specific page you need some contents from a Multilanguage content table get data from that table and store in JS array. You can extract and display straight (no script) but in that case you must reload pages or use HTMLRequest. Note : For messages, I mean all appear on screen you need anyway a language txt file for each language. What you want to do is not simple at all. I have implemented this system for many sites, one of them with millions of records and hundreds of tables (I worked in Europe for a while). Kind Regards, Lari Corifeanu Programmer [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Tel- 02-9699-0088 Tel- 02-9699-4099 87-97 Regent Street, Chippendale, Sydney, 2008 www.sydneyweb.com.au <http://www.sydneyweb.com.au/> www.sydneyseo.com.au <http://www.sydneyseo.com.au/> get your website found by search engines. www.powermail.com.au <http://www.powermail.com.au/> Our newsletter product - keep in touch with your clients and prospects. _____ From: wsg@webstandardsgroup.org [mailto:[EMAIL PROTECTED] Sent: Thursday, 21 December 2006 4:30 AM To: wsg@webstandardsgroup.org Subject: digest for wsg@webstandardsgroup.org From: "Roberto Scano - IWA/HWG" <[EMAIL PROTECTED]> Date: Tue, 19 Dec 2006 18:51:52 +0100 Subject: RE: [WSG] Multi language web sites I prefer to define all by database, with UTF-8 support (using Mysql db). This will guarantee also support for different languages and charset like japanese, arabic, etc. For fixed strings I prefer also to use XML. You can see an example in http://demo.fruibile.it/backo <http://demo.fruibile.it/backoffice> ffice -----Original Message----- From: listdad@webstandardsgroup.org [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, December 19, 2006 5:14 PM To: wsg@webstandardsgroup.org Subject: Re: [WSG] Multi language web sites There is a book (available from Amazon) I've found helpful titled "Beyond Borders: Web Globalization Strategies" by John Yunker, C. 2003. http://www.amazon.com/Beyond-Borders-Web-Globalization-Strategie s/dp/0735712085/sr=8-9/qid=1166544689/ref=pd bbs 9/103-3373738-5589 413?ie=UTF8&s=books Hope it helps, I'm interested to read other posts on this topic. Chris Block Global Web Producer Cummins Power Generation 1400 73rd Avenue N.E. Minneapolis, MN USA 55432 +1 (763) 574-5570 Direct +1 (763) 574-5811 Fax [EMAIL PROTECTED] Our energy working for you.⢠Kepler Gelotte <[EMAIL PROTECTED]> Sent by: listdad@webstandardsgroup.org 12/19/2006 09:03 AM Please respond to wsg@webstandardsgroup.org To wsg@webstandardsgroup.org cc Subject [WSG] Multi language web sites Hello, I had a question about creating multi-language web sites and best practices. Is it better to create two separate directories with the pages and images duplicated for each language, or is it best to try a database solution using meta tags that will be replaced on the server depending on the language selected? Maybe there is another approach all together? I would think the database solution would be more flexible but could get out of hand quickly just with the number of meta tags required. The web site I am concerned about has to support 2 languages only (French/English). Any comments are appreciated. Regards, Kepler Gelotte http://www.neighborwebmaster.com ********** ********************************************************* List Guidelines: http://webstandardsgroup.org/mail/guidelines.cfm Unsubscribe: http://webstandardsgroup.org/join/unsubscribe.cfm Help: [EMAIL PROTECTED] ************************************* ****************************** This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ************************************************ ******************* List Guidelines: http://webstandardsgroup.org/mail/guidelines.cfm Unsubscribe: http://webstandardsgroup.org/join/unsubscribe.cfm Help: [EMAIL PROTECTED] ************************************* ****************************** From: Sean <[EMAIL PROTECTED]> Date: Tue, 19 Dec 2006 18:39:28 +0000 Subject: Re: [WSG] Multi language web sites i was about to send an email with the same question aswell, i think the way i was going to go about it was database route unless anyone has any other suggestions. Sean From: Kepler Gelotte <[EMAIL PROTECTED]> Date: Tue, 19 Dec 2006 13:53:05 -0500 Subject: RE: [WSG] Multi language web sites Thanks for the responses. I realize my question was a bit off topic for this list so I moved the discussion to the forum. Regards, Kepler From: Paul Novitski <[EMAIL PROTECTED]> Date: Tue, 19 Dec 2006 11:49:04 -0800 Subject: Re: [WSG] Multi language web sites At 12/19/2006 07:03 AM, Kepler Gelotte wrote: >I had a question about creating multi-language web sites and best practices. >Is it better to create two separate directories with the pages and images >duplicated for each language, or is it best to try a database solution using >meta tags that will be replaced on the server depending on the language >selected? Maybe there is another approach all together? > >I would think the database solution would be more flexible but could get out >of hand quickly just with the number of meta tags required. The web site I >am concerned about has to support 2 languages only (French/English). The decision whether to generate web content from a database is often driven by the efficiency of doing so for middlin' to large applications. However, once you build a good method for supplying multilingual content, it's there for you to use on even small jobs. Here are two bilingual sites I've built using somewhat different techniques: Partcon (English/French site) http://partcon.ca/ With Partcon, the English & French are in separate records in the MySQL database. I set a language field in the database table with (in this case) three possible values, "-", "EN", and "FR". The hyphen stands for 'any language' and is used to output content that isn't language-dependent such as image src and anchor href. Therefore I can select records: WHERE lang='-' OR lang='$sSelectedLanguage' and the Boolean overlap of recordsets works just fine. When the user changes the language selection, a new page view is pulled down from the server with the requested language records plugged in. Laurie Toby Edison - Women of Japan - The Models' Words (English/Japanese pages) http://laurietobyedison.com/WOJwords.asp With Laurie Edison's Women of Japan pages, both the English and the Japanese texts are present on every page of mark-up. Which language is currently displayed depends on the body class ('langEN' or 'langJP'). Each language-specific block of text, whether a single span or a div containing multiple paragraphs, is given a language code so that CSS can display or hide text selectively: /* make English invisible on Japanese pages and vice versa */ body.langEN .langJP, body.langJP .langEN { position: absolute; left: -1000em; } With JavaScript disabled, changing language pulls down the same page from the server but with the body class reset. With JavaScript enabled, the body class is changed immediately and no server round-trip is required. Obviously this solution depends on a relatively limited amount of text on the page and/or a limited number of languages if you want to keep page size down. Regards, Paul From: Micky Hulse <[EMAIL PROTECTED]> Date: Tue, 19 Dec 2006 12:18:14 -0800 Subject: Re: [WSG] Multiple Suckerfish dropdown mayhem I cobbled this together a year or so back... allows for two, or many more, suckerfish menus on one page... I have yet to re-visit and clean-up the JS and/or CSS... but the main thing that should help you is the JS. Maybe it will give you some good ideas and/or a starting point. Cheers, Micky -- Wishlist: Switch: BCC?: My: From: "Nisha Kumari" <[EMAIL PROTECTED]> Date: Wed, 20 Dec 2006 17:11:12 +0530 Subject: getting XUL response from servlet Hi All, I am writing a application in XUL, which sends request to servlet for the authentication of the user. Which internally talk to database. But I am not able to return response from servlet to XUL, as XUL talks through JavaScript only. And I am not able to return response from servlet to JavaScript. I am new to XUL. Can any one please help me out with this? Regards, Nisha. ************************************************************** Guidelines: http://webstandardsgroup.org/mail/guidelines.cfm Unsubscribe: http://webstandardsgroup.org/join/unsubscribe.cfm Help: [EMAIL PROTECTED] ************************************************************** ******************************************************************* List Guidelines: http://webstandardsgroup.org/mail/guidelines.cfm Unsubscribe: http://webstandardsgroup.org/join/unsubscribe.cfm Help: [EMAIL PROTECTED] *******************************************************************
