Unfortunately I've never had to do it on a shared box, probably worth seeing
if they'll add it anyway? If all their sites are CF/mySQL then I believe it
can do no harm?
However if they don't want to play ball, then could you possibly ( and I
stress possibly, I've never tried this) use your request scope to control
it, it'd mean adding connectstring="#REQUEST.connectstring#" to each of your
CFQUERY's, and specifying
"REQUEST.connectstring=useUnicode=true&characterEncoding=ISO-8859-1" in your
applicatiion.cfm, but it 'might' just work?
Let me know if you have any luck!
Kev
----- Original Message -----
From: "Mark M" <[EMAIL PROTECTED]>
To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 03, 2004 10:01 AM
Subject: [cfaussie] RE: Bad Characters
> 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
>
>
---
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
