First of all, please forgive me if this message lacks clarity, I am
struggling to express my question correctly.
I am developing a multi-lingual web application, using cold fusion, an
apache web server, and sql server 7. The languages used are english,
french, german, spanish, italian, polish, and russian.
The application will be used to create, administer and take bookings for
events. When an event is set up, questions can be added that the person
booking is required to answer.The questions will be in added all of the
languages, but will only appear in the language of the person booking.
I want to have a page to input the questions that consists of 7 text boxes,
one for each language. I want to be able to copy text from a word document
containing the question in a specific language, in to the respective text
box, and when the page is submit, this text is then stored in the database
in its original form (by this i mean not using a numeric character
reference.)
I am struggling to overcome the first hurdle: I have copied russian text
from a web page in to a word document, when i try to copy this directly in
to a field in sql server, it produces a string of question marks - ????????
Could someone please tell me
a) how to copy russian (or anything not included in the iso-8859-1 character
set) directly in to sql server
b) Can using unicode solve my problems with input (if so, I assume i set the
encoding of the web page to utf-8, but how do I set up sql server and do I
need to do anything different with cold fusion)
c) If the text is stored in the db correctly, will it be output (on a web
page) correctly as long as the encoding is set to utf-8
Any help would be very much appreciated,
Jamie Griffiths
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
This archive was generated by hypermail 2.1.2 : Mon Mar 04 2002 - 12:21:36 EST