I've got this really wierd problem.

I'm building a cms type application and it works perfectly on my dev. server.

When I try it on the live server online it's a different story.

The problem is to do with it for some reason adding a capital A circumflex character before any special characters in the mysql db.

So for example, if the user enters the following into the form field and clicks submit:

English price @ £12.50

on my local server it adds exactly that to the mysql table. I then display it with a little function that converts all of the special characters (the pound sign for example) into the correct html (in the case of the pound sign it's £ ).

On the live server online it adds an A Circumflex character just before the pound when the record is commited to the mysql table.

Anyone have any ideas why it's doing this. I think it must be something to do with encoding or some mysql setting but I can't seem to find a solution. I could just make sure to strip out those A circumflex characters but I want to get to the root of it if I can.

Doing a google search for :

mysql "circumflex" appended

brings up loads of links to dodgy porn sites for some reason (wtf?)

Any ideas anyone?

Nevermind. Figured it out a few minutes after posting. The header of the submitting page was using a different character encoding standard than the mysql db. DOh!