Page 1 of 1

 <---- What?

Posted: Wed Jan 21, 2009 3:53 am
by Yanayaya
Hello Guys,

I have come across an issue I have never seen before, perhaps someone can shed some light on what is causing this.
I have a web form that requires the entry of a currency value (i.e. £10) however when you type a currency in including the "£" symbol, the data that gets imput into mySql is "£10".

Where is the "Â" coming from as it is being displayed on my database pulls? Any ideas? :crazy:

Re: Â <---- What?

Posted: Wed Jan 21, 2009 4:41 am
by requinix
It's an encoding issue. Something is sending data in ISO-8859 format and another is expecting it in UTF-8 format. Like a Spaniard and an Iraqi: nobody understands each other.

I prefer UTF-8 for everything simply out of preference. Just make sure that the HTML page with the form, database table, and the HTML page that shows the data all use the same encoding/collation.
Take a look near the bottom of this article ("Working with UTF-8 on the Web") for hints and ideas.

Re: Â <---- What?

Posted: Thu Jan 22, 2009 7:59 am
by Yanayaya
What an excellent article, thank you very much for the link. Problem has been resolved. :)