PHP/MySQL存在编码问题

我在PHP编码方面遇到了问题。

我有一个JavaScript/jQuery HTML5页面,可以使用$与我的PHP脚本交互。邮递 然而,PHP面临着一个奇怪的问题,可能与编码有关。

当我写作时

htmlentities("í")

我希望PHP能够输出 í .然而,它却输出 í 然而,一开始,我以为我在编码上犯了一些错误

htmlentities("í")=="í"?"Good":"Fail";

输出“失败”,在哪里

htmlentities("í")=="í"?"Good":"Fail";

但是 htmlentities($search, null, "utf-8") 一切正常。

我想让PHP与MySQL服务器通信,但它也有编码问题,即使我使用utf8_encode。我该怎么办?

编辑:在SQL命令上,编写

SELECT id,uid,type,value FROM users,profile
WHERE uid=id AND type='name' AND value='XXX';

其中XXX不包含íchar,按预期工作,但如果有任何íchar,则不包含。

SET NAMES 'utf8';
SET CHARACTER SET 'utf8';
SELECT id,uid,type,value FROM users,profile
WHERE uid=id AND type='name' AND value='XXX';

它不仅对íchars失败,而且对没有任何“特殊”字符的字符串也失败。 从集合名称和集合字符集中删除“char”似乎不会改变任何东西。

我正在使用PDO连接MySQL数据库。

编辑2:我使用的是Linux版XAMPP的MySQL版本5.1.30。

编辑3:跑步 SHOW VARIABLES LIKE '%character%' 从PhpMyAdmin输出

character_set_client    utf8
character_set_connection    utf8
character_set_database  latin1
character_set_filesystem    binary
character_set_results   utf8
character_set_server    latin1
character_set_system    utf8
character_sets_dir  /opt/lampp/share/mysql/charsets/

从我的PHP脚本(带有print_r)运行相同的查询输出:

Array
(
    [0] => Array
        (
            [Variable_name] => character_set_client
            [0] => character_set_client
            [Value] => latin1
            [1] => latin1
        )

    [1] => Array
        (
            [Variable_name] => character_set_connection
            [0] => character_set_connection
            [Value] => latin1
            [1] => latin1
        )

    [2] => Array
        (
            [Variable_name] => character_set_database
            [0] => character_set_database
            [Value] => latin1
            [1] => latin1
        )

    [3] => Array
        (
            [Variable_name] => character_set_filesystem
            [0] => character_set_filesystem
            [Value] => binary
            [1] => binary
        )

    [4] => Array
        (
            [Variable_name] => character_set_results
            [0] => character_set_results
            [Value] => latin1
            [1] => latin1
        )

    [5] => Array
        (
            [Variable_name] => character_set_server
            [0] => character_set_server
            [Value] => latin1
            [1] => latin1
        )

    [6] => Array
        (
            [Variable_name] => character_set_system
            [0] => character_set_system
            [Value] => utf8
            [1] => utf8
        )

    [7] => Array
        (
            [Variable_name] => character_sets_dir
            [0] => character_sets_dir
            [Value] => /opt/lampp/share/mysql/charsets/
            [1] => /opt/lampp/share/mysql/charsets/
        )

)

跑步

SET NAMES 'utf8';
SET CHARACTER SET 'utf8';
SHOW VARIABLES LIKE '%character%'

输出一个空数组。