[SOLVED] All of the apostrophes in my database come out as squares! I tried adding a \...

[Tylor_Famous]

Hello,

Every word in my database that has an apostrophe (like "it's") comes out as itXs (but the x is a square. Or a question mark in firefox). I saw something online once that said I had to add a \ before each one (it was a while ago so I don't remember exactly what it said) but it didn't work.

Any ideas?

[fenway]

Sounds like an enconding issue....

[Tylor_Famous]

And how might I solve it?

[Tylor_Famous]

I fixed the problem (might not be the best way but it works). I just pasted everything into work and did a find replace for the apostrophes with ‚

 

If anyone else needs to know some other ones I had to change are

 

' = ‚

- = —

" = "

 

There is a whole list here:http://www.chaos.org.uk/~eddy/bits/chars.html

 

Thanks