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.;
