> > 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:230326 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
