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/
