CFFILE and extended ASCII/accented characters

[tomtedeschi]

Hello-
I'm using CF 6.1 as a front-end to a MySQL database that happens to contain
extended ASCII characters (e.g., accented vowels). CF displays the characters
correctly onscreen, but if I use CFFILE to try to output to a file the
characters are converted to something strange -- question marks or some other
kind of extended character.

In CF-Admin, I've set the connectionstring for the MySQL database to:
useUnicode=true&characterEncoding=ISO-8859-1

I've also created an Application.cfm file in the root directory of my CF
application with the following contents:

<cfapplication name="journalist_project">
<cfcontent type="text/html; charset=ISO-8859-1">
<cfscript>
setencoding("form", "ISO-8859-1");
setencoding("url", "ISO-8859-1");
</cfscript>
<cfprocessingdirective pageencoding="iso-8859-1">

Any thoughts? Thanks in advance!

- Tom Tedeschi

[PaulH]

while i don't think this is required, you might try adding a charset="iso-8859-1" to your cffile call.

[tomtedeschi]

Thanks for the quick reply, Paul. I forgot to mention that I did do that. The
characters were encoded as some kind of unintelligable high-ASCII characters
(ellipses, degree signs, etc.), but not as accented ones. I tried a number of
different encodings in CFFILE, but the result was the same. Just to be sure, I
then changed the code so that the output was to the screen rather than to the
file, and all looked fine. Go figure.
- Tom

[PaulH]

then i'll guess some kind of mysql monkey business maybe mangled the chars. can
you put in fresh data & see?

btw <cfprocessingdirective pageencoding="iso-8859-1"> has to go on each cf
page it won't work from the application.cfm