[SOLVED] UK Pound CharSet

[MadTechie]

I have a slight problem where whenever i enter a UK Pound Sign into the database it seams to convert to a  £, i have no idea why the  is appearing i assume its the charset which is 'utf8_general_ci' has anyone come across this before ?

 

anyideas how i can resolve it ?

 

 

[effigy]

That's the correct UTF-8 encoding; see pound. Make sure your output is UTF-8.

[MadTechie]

humm that site states

decimal: £

UTF-8 (c2, a3) £

 

now the £ is what i am getting, the system was outputting correctly when reading from another database..

 

i am kinda at a loss on how to resolve this..

[effigy]

What exactly is the problem? You're not getting a pound sign when pulling data out of the database? Are you connecting to the database properly? What about your META charset?

[MadTechie]

I am storing data into the database, but when i pull the date back all the £ convet to £,

i have view'd the data in the database via phpMyAdmin and they are being stored as £,

 

i have also trid converting £ to '£' but then the database stores the data as "£"

 

what i want, is for the data to be stored without the 'Â'

 

if i do the following in phpMyAdmin

UPDATE `myTable` SET `myField` = '£1.99';

all is fine..

 

also

UPDATE `myTable` SET `myField` = '£1.99';

 

all works well FROM phpMyAdmin,

 

But if i perform the exact same SQL statement from my own php program it updates to '£1.99' or '£1.99'

 

the reason i believe its a SQL problem rather than a PHP problem is because i had this exact same problem a few weeks ago when i move my code to another server.

 

the thing thats the biggest pain is after the move i fixed it by changing the charset from 'latin1_swedish_ci' to 'utf8_general_ci' <-- it think,

 

i hope that makes sense..

[MadTechie]

Oh and the input is from a form

 

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

 

[MadTechie]

Erm...

 

I started to take at this problem today and its working!!

 

I played with it last night with no luck.. but this morning its ok!!!

 

???