Just to check -
I got the same problem (haven't tested it out yet)
On shared hosting, obviously can't get to the connection string - will the setEncoding
work
anyway?
Mark
------------------------------------------------------------------
[EMAIL PROTECTED]
ICQ: 3094740
Safe From Bees
[ www.safefrombees.com ]
Quoting Matthew Bryant <[EMAIL PROTECTED]>:
> Love your work Kevin. Worked a treat!
>
> 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
>
>
>
---
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
