Tip: Display unicode data from mySQL DB on a website in PHP.

Before we start we need to make mySQL database capable of supporting unicode characters. For that we need to change the database collation or the table collation to utf8_unicode_ci. This can be done with phpmyadmin portal.

  1. Click the table you need to change.
  2. select Structure tab.
  3. Check the required column and click change or edit.
  4. From the collation drop down select utf8_unicode_ci.
  5. Press Go.

Click here to read more