I had a similar problem .. and I spent ages and ages tearing my hair out trying to work out what it was .. all my � signs were coming in as ? .. I set encoding, content type all that stuff .. it turned out that I needed a connection string in the CF administrator for the MySQL datasource that sets the encoding to the right one. (im sorry I cant paste the exact string but it was on an old project I no longer have access to .. but look for it in the mysql help !)
For some reason it doesn't need this connection string for it on windows (which added extra head scratching time in me trying to figure out what was wrong lol) Hope this aids in someway to solving the problem ! Regards Stephen -----Original Message----- From: Dave Phipps [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 14:43 To: ColdFusion User group Subject: [ cf-dev ] Encoding strangeness in MX6.1 Hi, I know that MX is now Unicode and as such text is encoded as UTF-8 by default but can anyone explain this: I am using fusebox so all calls go via index.cfm. In my index.cfm I am using the following to change the encoding to iso8859-1 <cfprocessingdirective pageencoding="iso-8859-1"> <cfset setEncoding("URL","iso-8859-1")> <cfset setEncoding("FORM","iso-8859-1")> <cfcontent type="text/html; charset=iso-8859-1"> Then I have a query which grabs some text from the db and I then output that so I get things like the following: Trading Faces presents ?Creaking Shadows? Which should read: Trading Faces presents "Creaking Shadows" When I look at the db I can see that the punctuation is correct yet the output is always incorrect no matter what encoding I set. Where am I going wrong or what have I missed. The db is MySQL 4 on Linux and the fields are varchar. Cheers Dave -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
