Kind regards, Mat.
Kevin Faulkner wrote:
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
--- 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
