utf8_unicode_ci似乎不是UTF8(utf8_unicode_ci seems not to be UTF8)

 我的mySql数据库有些奇怪...我的表格编码为“utf8_unicode_ci”，但是当我对它进行SELECT时，数据似乎不是UTF8，因为json_encode给出一个空字符串。 
 
 我必须重新浏览结果以重新编码UTF8中的数据... 
 
    $q = $this->db->prepare("SELECT ...");

    $q->execute();

    $data = $q->fetchAll();

    foreach ($data as $key => $value) {
        $data[$key] = utf8_encode($value);
    }

    return $data;
 
 在那之后，json_encode完成了他的工作。 但是我不明白为什么我的表格中的SELECT结果在“utf8_unicode_ci”中编码不会直接提取UTF8中的数据...重新浏览数组是非常多余的... 
 
 感谢帮助 

I got something strange with my mySql database... My tables are encode in "utf8_unicode_ci", but when I make a SELECT on it, data seems not to be UTF8 because json_encode give an empty string.
 
I have to re browse the result to re-encode the data in UTF8...
 
    $q = $this->db->prepare("SELECT ...");

    $q->execute();

    $data = $q->fetchAll();

    foreach ($data as $key => $value) {
        $data[$key] = utf8_encode($value);
    }

    return $data;
 
After that, json_encode do his job. But I don't understand why the SELECT result from my table encode in "utf8_unicode_ci" doesn't extract the data in UTF8 directly... It is very redundant to re-browse the array...
 
Thanks for help

原文：https://stackoverflow.com/questions/43472912