Mat,
Are you on MX- because there is a small issue with encoding of character
sets with MySQL I/O . If you're getting squares instead of quotes for
example then try this...
In your application.cfm add the following:
<cfset setEncoding("url","ISO-8859-1")>
<cfset setEncoding("form","ISO-8859-1")>
<cfcontent type="text/html; charset=ISO-8859-1">
Some recommend adding this to each tempolate but I've never seen any
difference...
<cfprocessingdirective pageEncoding="ISO-8859-1">
But this is the trick I've always had success with...and in the advanced
option, connection string, for the DSN you should add:
useUnicode=true&characterEncoding=ISO-8859-1
----- Original Message -----
From: "Clifton Steve" <[EMAIL PROTECTED]>
To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 03, 2004 8:46 AM
Subject: [cfaussie] RE: Bad Characters
Mat,
Do you mean the "Smart Tags"? Try the following before your insert:
<cfset newtext = Replace(newtext, chr(145), chr(39),"ALL")> <!---
"single open" --->
<cfset newtext = Replace(newtext, chr(146), chr(39),"ALL")> <!---
"single closed" --->
<cfset newtext = Replace(newtext, chr(147), chr(34),"ALL")> <!--- "dbl
open" --->
<cfset newtext = Replace(newtext, chr(148), chr(34),"ALL")> <!--- "dbl
close" --->
<cfset newtext = Replace(newtext, chr(150), chr(45),"ALL")> <!---"short
hyphen" --->
<cfset newtext = Replace(newtext, chr(151), chr(45),"ALL")> <!---"long
hyphen" --->
<cfset newtext = Replace(newtext, chr(133), "&##133;","ALL")> <!---
"elipsis" --->
Regards,
Steve c
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Matthew
Bryant
Sent: Wednesday, 3 March 2004 10:38 AM
To: CFAussie Mailing List
Subject: [cfaussie] Bad Characters
Anyone out there come across the issue and even better, a fix, for
copying and pasting a word document that contains "Inverted Commas" into
soEditor (or other WYSIWIG HTML Editor) and it saves dodgey characters
(squares, instead of Inverted Commas) into the database (mySQL).
Regards, mat.
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
