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/
