选择在从表中选择马拉雅拉姆语字符串时返回问号的查询

Question

我的php代码如下：

<?php
    $username = "root";
    $password = "";
    $hostname = "localhost";
    $db="newsportaldb";
     $dbhandle = mysql_connect($hostname, $username, $password) 
     or die("Unable to connect to MySQL");
     $selected = mysql_select_db($db,$dbhandle) 
     or die("Could not select DB");
    $sql= mysql_query('select username from tbl_login');
            while($rss= mysql_fetch_array($sql))
                {  
        $ress["homepagecontents"][] = array("titles"=>$rss['username']);
                        }
                    echo json_encode($ress);
        mysql_close($dbhandle);
    ?>
//in this case we getting "?????????????????" as a result of echo json_encode($ress);

Answer 1

问号来自错误的字符集。确保连接具有正确的字符集 （utf8）。如果在phpmyadmin上您没有正确看到数据，请将db，table和列更改为utf8_general_ci。热门推荐给你：升级你的代码并使用php PDO对象。祝你好运！