How to retrieve UTF-8 data from SQL database?

Question

After many attempts I couldn't get data from my database in a correct encoding (UTF-8) format.

This is my connection(config.php) file:

<?php
define("DB_HOST", "localhost");
define("DB_USER", "user");
define("DB_PASSWORD", "");
define("DB_DATABASE", "db");
$dbcon = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
?>

My php form for retriving data:

<?php 

include('config.php');
$sqlget="SELECT * FROM table";
$sqldata= mysqli_query($dbcon, $sqlget) or die ('error');
mysqli_set_charset('utf8');
echo"<table>";
echo"</table";
?>

If you just did a google query on php mysqli utf8 you would have wound the answer in the first result. — Bart
– Bart, Commented Apr 14, 2013 at 17:34

Hallonen · Accepted Answer · 2013-04-14 17:33:43Z

2

You're not sending the link identifier mysqli_set_charset($dbcon , "utf8");

from php manual:

bool mysqli_set_charset ( mysqli $link , string $charset )

And set it before you execute the query.

answered Apr 14, 2013 at 17:33

Hallonen

342 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Your Common Sense · Accepted Answer · 2013-04-14 17:30:14Z

1

setting encoding after SELECT is a bit late
set it before running any query

<?php
define("DB_HOST", "localhost");
define("DB_USER", "user");
define("DB_PASSWORD", "");
define("DB_DATABASE", "db");
$dbcon = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
mysqli_set_charset('utf8');

answered Apr 14, 2013 at 17:30

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Comments

Julio María Meca Hansen · Accepted Answer · 2013-04-14 17:38:42Z

1

The simplest way of achieving that is running any of these:

// for procedural MySQL (obsolete in PHP 5.4/5.5!)
mysql_query("SET NAMES 'utf8';", $link);

// for procedural MySQLi
mysqli_query("SET NAMES 'utf8';", $link);

// for MySQLi, function notation
mysqli_set_charset($link, "utf8");

// for MySQLi, method notation
$mysqli->set_charset("utf8");

// for PDO
$pdo = new \PDO("mysql:host={$host};dbname={$database};charset=utf8", $user, $password);

That will guarantee the retrieved data will be returned with UTF-8 encoding.

Hope that helps :)

answered Apr 14, 2013 at 17:38

Julio María Meca Hansen

1,2681 gold badge20 silver badges40 bronze badges

Comments

Daan Olislagers · Accepted Answer · 2013-04-14 17:31:10Z

0

Try setting the charset before your query.

answered Apr 14, 2013 at 17:31

Daan Olislagers

3,2532 gold badges19 silver badges35 bronze badges

Comments

Marcin Orlowski · Accepted Answer · 2013-04-14 17:31:32Z

0

Order is important. You need to set connection encoding before you start executing queries, otherwise it's just too late:

mysqli_set_charset('utf8');

shall be executed just after you connect:

<?php
define("DB_HOST", "localhost");
define("DB_USER", "user");
define("DB_PASSWORD", "");
define("DB_DATABASE", "db");
$dbcon = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);    
mysqli_set_charset('utf8');

answered Apr 14, 2013 at 17:31

Marcin Orlowski

75.7k11 gold badges128 silver badges152 bronze badges

Collectives™ on Stack Overflow

How to retrieve UTF-8 data from SQL database?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related