werid Â character
The database is MySQL charset: UTF-8 Unicode (utf8) and I believe the database collation and table collation is set to utf8_general_ci
I'm thinking it might be my hosting server as my internal testing server works fine.
What I've noticed is when I add the £ symbol in the global currency or page attribute and save the page it shows fine and I went into the database and the symbol seems to be entered into the database as UTF-8.
Now this is where it gets strange. When I view the page everything shows fine including the static cart page for the e-commerce package.
The problem seems to occur when the value is retrieved and displayed via the dialog boxes. I dont fully understand how C5 retrieves the values so could it be a php.ini or server problem.
Thanks in advance
Your database is storing the data in UTF-8; whereas the web servers default character set is ISO-8859-1.
If you add the following to your htaccess, then this should fix the issue: