Drupal Association members fund grants that make connections all over the world.
Some of the most important fields in our webform are essay questions. We ask the users to answer these questions in "text area" elements. When users type directly into the field, everything goes well. Unfortunately, most people seem to prefer to compose their answers separately in a word processor, then copy and paste into the field (allowing them to spell check, save work, revise, etc). This creates a very frustrating problem: their word processor is often based on a different character set than whichever set it is that drupal webform is used to handling (be it unicode, utf, asci, or something else). Thus, commas, quotation marks, and other punctuation comes through in the (comma separated values) results as incomprehensible gibberish. This forces us to spend valuable time in excel cleaning up our data to make it presentable for the people who will be evaluating the webform submissions. How can we avoid this? Is there any kind of control over character encoding that might work around this? I have scoured the forums for other instances of this problem, but have found no discussion. Please help. Thanks!