All:
Im trying to read content from an XML file stored on disk, fiddle with it, and save it to a database. It all works fine except for when the content includes smart-quotes (the XML file is a spreadsheet exported from MS Excel to XML Spreadsheet 2003 format). When I use CFFILE to read the XML file, without specifying a character set, the smart quotes get turned into 3 other characters. For example, an opening quote (ASC value of 8220) gets turned into ï¿ ½ (239-191-189). When I specify a character set, I either get the same results or, using utf-8, I get a single, unprintable character with an ASC value of 65533, regardless of what the starting character actually was. If I enter the offending string directly into my CF code, or into a textarea in a form, the string is read as expected. Its only a problem when the string is read via CFFILE. Any suggestions on what character set I should use or, barring that, another means of reading the content from the disk? TIA -- Mosh Teitelbaum evoch, LLC http://www.evoch.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328981 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
