[stealthcow]

Wordpress seems to be storing strange characters in the database when I add a post (eg "Women’s Arts International Festival, Cumbria")

When I output it in my custom way, it shows this stupid ’, but when wordpress outputs, it shows it fine - what the hell is it doing?


I've been googling for the past hour or so - it seems that people have been having this problem and its to do with encoding (UTF-8) to be precise. Everyone has been talking about the problem, but noone has given the answer (even after they say they have made it work)

Any help would be appreciated!

[emil]

MarteyDodoo.com » Wordpress UTF-8 Charset Woes

maybe?

[stealthcow]

that screwed it up even more :|

have a look at the page now!

[stealthcow]

the stupid thing is that it shows fine in the wordpress admin and the wordpress front end, but not in the DB - so what is wordpress doing that im not?

[steveb]

Can you open up the file in MetaPad and search/replace incidences of the offending apostrophes with the relevant code, e.g. ’ = & # 8 2 1 7 ;

Then it can't help but display properly.

[stealthcow]

i could, but that would take a loooong time (ive just installed wordpress with our custom frontends on about 5 sites and got people to input the content, we only noticed after it was too late), so i need a solution that could be done in PHP by processing the output, could do a search replace using PHP but that'll become server heavy pretty quickly

[steveb]

I take your point!

You'd think by 2007 it would be possible to display basic punctuation. But noooo.

[stealthcow]

any more ideas?

[steharg]

give them a ring and see if they'll rename the festival so its compatible with wordpress, or just call it WAIF

[stealthcow]

great help... anyone else?

[stealthcow]

fixed it...

<?php
header('Content-Type: text/html; charset=utf-8');
?>

at the top of every page, kushti

[steveb]

Well done and thanks for not keeping the solution a secret.