Paul, We are still having problems with the clients receiving email and the characters not being correct as above.
They are using Lotus notes, and we cant replicate the problem, we have used localised versions on hotmail, gmail, outlook etc etc We took your advice and put in the <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> to the emails and we still have the data appearing correctly. Unfortunately not for the client. Do you have any more suggestions? Regards Duncan On 12/22/05, Paul Hastings <[EMAIL PROTECTED]> wrote: > Duncan wrote: > > <cfif saveAsUnicode>N</cfif>'some text here for this value' > > why bother? why not just stuff the data straight in, N'sometext'? > > > I want to avoid using the n notation, I have no problem with n datatypes. > > if you don't use cfqueryparam & turn on the unicode option for that dsn, > then you *have* to use unicode hinting. > > > What do we need to do to SQL server to make this happen? > > nothing. > > > Do we need to change something in CFMX 6.1 to make this work? > > use cfqueryparam & turn on the unicode option for that dsn, it's a good > practice in any case. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229128 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
