UTF 8 encoding not working properly in PHP
html, mysql, php, utf8-decode
Solution
The character set needs to be defined in a few different places:
The MySQL database
The text stored in the database might not be encoded as UTF-8. You can define a default character set as part of the `create database` statement:
CREATE DATABASE mydb CHARACTER SET utf8;
You can also specify per-column character sets with `create table`.
Within your PHP code
You'll need to tell your client-side code which encoding it should use when communicating with the database.
If you're using PDO, you can specify the character set as part of the DSN string:
$dsn = 'mysql:host=localhost;dbname=testdb;charset=utf8';
$dbh = new PDO($dsn, $username, $password);
If you're using MySQLi, you can use the `mysqli_set_charset()` function/method:
$dbh->set_charset('utf8');
or:
mysqli_set_charset($dbh, 'utf8');
Alternatively, the MySQL website suggests issuing a statement after connecting to the server:
SET NAMES 'utf8';
Within the HTML output
For HTML5, you can simply add the following `<meta>` tag within the `<head>` element of your output:
<meta charset="utf-8">
Problem
I am trying to print data from MySql database. I have a simple problem it is showing `D�lar` instead of `Dólar` . Although I have included ``` <META http-equiv="Content-Type" Content="text/html; charset=utf-8"> ``` In my html page so can any one help me out with this Thanks in Advance