why am i getting this Â£10 using charset=utf8

Question

If i enter a £ (UK Pound Symbol) into my DB why does it always add to the database with as Â£.

I thought this was down to the charset but thought utf8 should cure this

EDIT i am setting the charset as below

$db = new PDO('mysql:host='.DBHOST.';dbname='.DBNAME.';charset=utf8', DBUSER, DBPASS);

any advice please.

Read this: http://stackoverflow.com/a/279279/1679849 – r3mainer Nov 09 '13 at 01:27 — r3mainer, Nov 09 '13 at 01:27

score 0 · Answer 1 · answered Nov 09 '13 at 01:26

0

Use this before any other query

SET NAMES utf8;

answered Nov 09 '13 at 01:26

Mihai

$db->exec('SET NAMES utf8;') – Mihai Nov 09 '13 at 01:31
Why has this been marked down? it WORKS perfectly! i have tried stackoverflow.com/a/279279/1679849 but am already doing everything it suggests (i think) but adding $db->exec('SET NAMES utf8;') to the INSERT query seems to have fixed the issue! – Ford Nov 09 '13 at 01:37

1 Answers1