Skip to main content
Inspiring
January 26, 2013
Answered

How to filter out \xE2\x80\xA8

  • January 26, 2013
  • 1 reply
  • 1470 views

Hi guys, i have a nasty problem with:

Incorrect string value: '\xE2\x80\xA8In ...' for column 'Body'

I have tried to set all db's to utf8, have set the my.ini to utf8, still not working, i am done...

How can i just simply use coldfusion to filter out all \xE2\x80\xA8 and alike codes?

Thanks for any direction!

Marco

    This topic has been closed for replies.
    Correct answer MarcovandenOever

    Mmmm although i created the databases with utf8 somehow the client charset etc was not set to utf8, everything is set to utf8 now so it works.... thanks

    1 reply

    MarcovandenOeverAuthorCorrect answer
    Inspiring
    January 26, 2013

    Mmmm although i created the databases with utf8 somehow the client charset etc was not set to utf8, everything is set to utf8 now so it works.... thanks