I am working on an application at the moment that is fully supports Il8n. German, English, French etc. Currency and number conventions etc. CF does it pretty well.
To start with, either check out resource files and the il8n support in Java. A good place to get the functionality for this is from the Struts tag library or the java standard tag library. The cool thing is that this stuff slots straight into CF. Or if you want straight CF have a look at www.benorama.com. The guy has some functions written that can help you. Simple to use and it is really fast. All of this will give you the support for all of your static text throughout your site. Essentially it works like this: you have multiple resource files (i.e. text_en.properties, text_de.properties etc.) in which you put the translated text that is associated with various keys. For instance: text_en.properties YES=Yes No=No text_de.properties YES=Ja NO=Nein For the database side of things, this gets trickier as the multi lingual support adds complexity. There are two ways that I thought of, concatenated keys (i.e. a primary key made up of an 'id' and a 'languageId'). For instance: Product Table ProductID ProductName LanguageId 1 Tube en 1 Schlauch de or a table that contains the primary key and then references the Product Table ProductID 1 Product Translation Table ID ProductName LanguageId ProductID_fk 1 Tube en 1 2 Schlauch de 1 Whatever you use is up to you. I am using the second method as it works into the limitations of the j2EE architecture easier but for CF the first method is easier. The method that you are hoping to use is easy to do but not very "scalable" to say the least. Additionally CF has a few Il8n support features that will also help you. All of the functions beginning with 'LS' are worth a look. I hope this gives you a few ideas to get you started. There are heaps of resources on this stuff. You just have to use Java (but no need to write code....). Just read the instructions and you will be ok. It is all tag based just like CF. Jordan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Taco Fleur Sent: Wednesday, 30 July 2003 3:09 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Mulitlingual support Whats the datatype in of the column you store it in? Is it varchar? If so, you might want to try NVARCHAR Taco -----Original Message----- From: Ricardo Russon [mailto:[EMAIL PROTECTED] Sent: Wednesday, 30 July 2003 11:08 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Mulitlingual support I have decided that the easiest way to do the site is to store the text in separate tables, and call it based on the language: SELECT * FROM #session.lang# WHERE page = '#url.cmd#' the problem is the encoding. Not speaking Japanese myself I copied some text from another .jp site. Using UTF-8 encoding, the text that I paste displays in the text box, as it does on the original site. I then submit the form, to store the text in the database. When I return the text from the database to the page, it is not displaying as it originally was. Is this a coding/CFMX/mySQL error? Do I have to upgrade to mySQL 4.x? Thanks Ricardo "Knott, Brian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Ricardo, > I have developed several site that contain 2 languages. I simply > create 2 site, one for each language. Not the easiest way to do it. A > better idea would be to have all the text dynamic and feed out of a > database. The admin person then has to cut and paste the correct text into > the database. You could set a session variable (or client) when the user > accesses the site, and display the correct language depending on the session > variable. > > Brian Knott > > -----Original Message----- > From: Ricardo Russon [mailto:[EMAIL PROTECTED] > Sent: Friday, 25 July 2003 11:10 AM > To: CFAussie Mailing List > Subject: [cfaussie] Mulitlingual support > > > Does anyone have any pointers on where to start with making a site support > multiple languages. > I need to convert my cart to support other languages, does CF have any built > in support. The translation is not the problem, just deciding which language > to display, > > I am trying to avoid developing a different site for each language. Any help > would be appreciated. > Thank you.. > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ ---------------------------------------------------------------------------- This email, together with any attachments, is intended for the named recipient(s) only and may contain privileged and confidential information. If received in error, please inform the sender as quickly as possible and delete this email and any copies from your computer system network. If not an intended recipient of this email, you must not copy, distribute or rely upon it and any form of disclosure, modification, distribution and/or publication of this email is prohibited. Unless stated otherwise, this email represents only the views of the sender and not the views of the Queensland Government. ---------------------------------------------------------------------------- --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
