Perfect, exactly what I was looking for and having added
charset="iso-8859-1" to a couple of cfhttp's I was doing it all now works.

Thanks.

--
Jay

> -----Original Message-----
> From: Paul Hastings [mailto:[EMAIL PROTECTED]
> Sent: 05 August 2004 18:06
> To: CF-Talk
> Subject: Re: Accented characters
>
> > I am using MySQL as a datasource and whenever an accented character
> > arises (é for example) it ends up being stored in the
> database as ' ' instead.
>
> for mx:
>
> in your application.cfm add:
> <cfset setEncoding("url","ISO-8859-1")>
> <cfset setEncoding("form","ISO-8859-1")> <cfcontent
> type="text/html; charset=ISO-8859-1">
>
> at the top of your cf pages add:
> <cfprocessingdirective pageEncoding="ISO-8859-1">
>
> in the advanced option, connection string, for that DSN add:
> useUnicode=true&characterEncoding=ISO-8859-1
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to