How to filter out \xE2\x80\xA8

[MarcovandenOever]

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

[MarcovandenOever · Accepted solution]

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