且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

我如何让MySQL返回UTF-8?

更新时间:2023-11-27 12:40:22

UTF-8 连接到数据库:

// Set up your connection
$connection = mysql_connect('localhost', 'user', 'pw');
mysql_select_db('yourdb', $connection);
mysql_query("SET NAMES 'utf8'", $connection);

// Now you get UTF-8 encoded stuff
$query = sprintf('SELECT name FROM place where id = 1');
$result = mysql_query($query, $connection);
$result = mysql_fetch_assoc($result);