Character Endoing £ sign is ?

[Adamhumbug]

I am having an issue with £ that i have in my database showing on my webpage as a triangle ?.

I have my database encoded as utf8_general_ci and i declare <meta charset="UTF-8"> in my head.

Is there something that i am missing here?

Help is appreciated.

Kind Regards

Adam

[requinix]

Does the value show properly with something like phpMyAdmin? Is your database connection set up to use UTF-8?

[Barand]

33 minutes ago, Adamhumbug said:

I have my database encoded as utf8_general_ci and i declare <meta charset="UTF-8"> in my head.

That's two out of the three. Ensure your connection to the DB sever is also utf8 EG

    $db = new PDO("mysql:host=".HOST.";dbname=".DATABASE.";charset=utf8",USERNAME,PASSWORD);
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
    $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

[Adamhumbug]

Thanks both.

I added the following to my database connection and that has done the trick.

mysqli_set_charset( $conn, 'utf8');

Thanks again,

Kind Regards

Adam