We have noticed that when we send an email and check it in Outlook the characters are correct. When we view the email in Eudora or a Web mail client we receive the incorrect characters.
A simple email form is at: http://oper1.karger.com/jfr/cfmtest.cfm When we use this form to send the string: ä, ö, ü, ß And check the email with a client other than Outlook we get a garbage string. When I posted the garbage string to the list it came back as the correct characters. ?? Any ideas? regards, Jeffrey > > We are having a problem with CFMAIL and special characters (ä, ö, ü, ß) > >define "problem". Characters sent as: ä, ö, ü, ß Return in email as: ä, ö, ü, ß > > The characters are stored in the SQL database > > correctly when input by users and display > > correctly on screen, but are lost when the text > >using what datatypes? by sql server you mean ms sql server? what driver >are you using ODBC or JDBC? MS SQL Server drivers. The text going out in the CFMAIL tag is coming directly from a form variable. This same form variable is then stored in a MS SQL table (ntext) which when viewed on screen is displayed correctly. > > is sent out using the CFMAIL tag. In the CF > > administrator the Mail Charset Setting is UTF-8 > > (8-bit Unicode Transformation Format). > >if you set the charset on the cfmail tag, does it help? No, this did not help. I tried charset="utf-8" within the CFMAIL tag. We are using CFMX 6.1 Thanks for your reply, Jeffrey ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230335 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
