Hi there,

I've recently upgraded to CF 7 from MX; everything works except special
characters (british pound signs, accents, etc) are converted to squares. I
understand this is a problem with character sets, and how CF 7 connects
differently than CFMX. I have found into here:
[url]http://www.markme.com/cantrell/archives/cat_coldfusion.cfm[/url] but it is not
helpful, as I have hundreds of datasources and do not want to rebuild them all.

Is there a solution to this problem? I've tried using a connection string
like "useUnicode=true&characterEncoding=iso-8859-1" as well as different
CFCONTENT options. Nothing seems to work for all character sets. Rolling back
to MX would be a big pain, but unless there is a solution to this I'll have to.
Any ideas?

Chris