£ prefixed with  in database 1

[theevilone]

Hi,

I have problem inserting data into my SQL Server db using Coldfusion MX.

When I insert the "£" symbol to denote GPB, in the data, the data is prefixed with a "Â". Is this a known issue. Any help or fixes would be appreciated.

Thanks,
Mary

 

[Sarky78]

Mary

if memory serves, I think this is a problem with the default encoding that CFMX uses. What we did is to put the following two lines into our Application.cfm file and this fixed the problem by forcing CFMX to use the this encoding.

<cfcontent type=&quot;text/html; charset=iso-8859-1&quot;>
<cfset setEncoding(&quot;form&quot;,&quot;iso-8859-1&quot>

hope this helps!

Tony

 

[theevilone]

Thanks Tony.

It works.

Mary