Getting strange characters when outputing memo from MS Access database

[Sinister747]

Hi All,

I am using FCKEditor to allow a client to input a news article.. and the output is saved in MS Access.

However when i output the record i get a "Â" character randomly positioned in the output.

For instance, in FCKEditor the client types

THE ANCOL IS REGARDED AS ONE OF THE BEST FOR LEADS AND COLLARS IN EUROPE. THEY ARE RENOWNED FOR THEIR QUALITY AND VALUE

but in the output it says

THE ANCOL IS REGARDED AS ONE OF THE BEST FOR LEADS AND COLLARS IN EUROPE. THEY ARE RENOWNED FOR THEIR QUALITY AND VALUE

Please help me with this...

[jhardman]

This is the reason I don't like wysiwyg editors -> you don't have control over what they actually do.

Look through the code for the page that saves the data. There should be a replace() function that replaces punctuation and special characters. I would modify this function so that every character it now replaces is replaced with HTML character codes (& becomes & etc). You might be tempted to remove this function, but I'm pretty sure it gives good security against SQL injection.

Jared