That's a bit of a pain. What other characters are going to mess it up? I think I had a related problem with worldpay submitting forms to CFMX adn the caracter encoding messing things up. Isn't there a urlencodedformat equivalent function that will do all this for me? ----- Original Message ----- From: "Dave Phipps" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 16, 2002 10:07 AM Subject: Re: [ cf-dev ] Weird sybols in DB
I also experienced this whilst developing a site using MX. The prod server was still running CF5 and this solved our problem. I think it has something to do with the default text encoding being UTF-8, but I may be wrong. I think you have to either convert them to £ or whatever the ascii code is for the � symbol. HTH. Dave At 09:59 10/16/2002 +0100, you wrote: >Errr, sorry what tdo you mean by that? > >----- Original Message ----- >From: "Aidan Whitehall" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, October 16, 2002 9:57 AM >Subject: RE: [ cf-dev ] Weird sybols in DB > > > > Can anyone tell me why I am getting a wierd capital A with a hat on before >� > > signs in a text field when I update a DB record? > >Is that the escape character for whatever RDBMS you're using? Maybe it's >automatically escaping it. > > >-- >Aidan Whitehall <[EMAIL PROTECTED]> >Macromedia ColdFusion Developer >Fairbanks Environmental +44 (0)1695 51775 > >________________________________________________________________________ >This e-mail has been scanned for all viruses by Star Internet. The >service is powered by MessageLabs. For more information on a proactive >anti-virus service working around the clock, around the globe, visit: >http://www.star.net.uk >________________________________________________________________________ > >-- >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] > > > >-- >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] ============================================ Phipps CF Development Oxford, Oxfordshire. Telephone: +44(0)7718 896696 http://www.phipps-cf.co.uk ============================================ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
