php / mysql / html5 and charset...
Posted on 2011-05-05
ok. I give in.
I have tried for ages, but can't solve this, I know there is going to be a simple solution - don't let me down experts.
I build content managed websites using php and mysql. I also use the webassist HTMLEditor pluging as my HTML editor of choice.
Recently I upgraded to HTMLEditor 3 and roughly at the same time, started using HTML5 (loving the curvy corners and wonky boxes), but I'm having an impossible issue with my charset and the content managed data...
The text that I edit/create using the HTML editor gives me <?> (black diamond with question mark) characters instead of £ (pound sugns) when it displays.
I am using the <meta charset=utf-8 /> as my charset definition. (tried all sorts of variations)
Here's the issue. If I type '£' into my document source, it renders as a £, but any £ entered via the HTML editor render as <?>. Using phpmyadmin to check what's being saved shows me a £.
I can't see any encoding settings on the webassist htmleditor, on file, it looks fine, entering £ into the source file works fine, but the stuff stored in MySQL, pulled in via PHP and 'echo'ed doesn't work...
Please help, someone. Been going on too long, so max points for a quick solution.
Got a client meeting in 10 hours, can anyone resolve?