this is stored in my mysql database

                <p>it&acirc;&euro;&trade;s the best</p>

I am fetching this from database and displaying to webpage. But "it'due south the all-time" is displayed as "it’s the best".

How can i show apostrophe on the webpage?

I want anybody who access my website come across the apostrophe irrespective of browser and bone.

asked Oct 12, 2022 at ten:57

3

  • share your codes too..

    October 12, 2022 at 10:58

  • which exotic encoding are you using?

    October 12, 2022 at 11:01

  • &acirc;&euro;&trade; is the HTML code for ’. You already have corrupted data in your database. You can try to repair by decoding all HTML entities to their 'ISO-8859-ane'-encoded characters. The resulting string will likely be a valid UTF-8 string.

    Oct 12, 2022 at 22:xiv

one Answer 1

when so always you find such special character problems from the database. Always follow some basic steps like below:

  1. check the column collation to be utf8_general_ci.
  2. run the query "SET NAMES utf8" before your bodily query.
  3. ready the content headers to utf-8 or endeavour with ISO-8859-1

if yet it doesn't help, then please paste/describe your lawmaking while asking the questions.

answered Oct 12, 2022 at 11:07

Not the reply you're looking for? Scan other questions tagged php html unicode or ask your ain question.