Thanks to all for the suggestions. I had to use a combo to fix it. We are on pre 4.1 I think due to it not being a fully stable release yet, or is it?
Anyway the fix was this:
Place the following in the index.cfm or Application.cfm:
<cfcontent type="text/html; charset=iso-8859-1">
then in the advance properties of the ODBC datasource in cf admin place the following in the connection string:
useUnicode=true&characterEncoding=iso-8859-1
This seems to have fixed the problem.
Thanks
Dave
At 10/27/2003 14:56, you wrote:
UTF-8 encoding is not supported by MySQL before version 4.1.
Do you have cfmx admin access if so you can change the default charset encoding
In the ColdFusion MX Administrator open the datasource properties for your MySql datasource, click on Advanced Properties, and put the following in the 'connection string' box: useUnicode=true&characterEncoding=iso-8859-1
A possible method to enable this would be to take your string and encode it in Base64 using the TOBASE64 function. You then store that in a text field in your database. To utilize your data after you will need to convert it to binary and then convert it to a string using the TOBINARY and TOSTRING functions .
I know I don't address your question Fully but It might aid you to Know that MYsql pre 4.1 Does have a lot of issues about encoding
-----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]
--- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003
-- ** 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]
