Ricardo,
I have a database that contains an answer table. This table
contains answers from questions. This table contain answers in both English
and Chinese. The Chinese answers are just basically symbols. The trick to
shown them correctly was to make sure your Internet explorer was set to read
the correct characters. Right click on the screen, choose encoding and
select the correct encoding. Display my Chinese characters perfectly.
Brian Knott
-----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/
---
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/
