SELECT * FROM tab_article WHERE a_title='��' ORDER BY a_id LIMIT 1<br />执行错误: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (utf8_general

SELECT * FROM tab_article WHERE a_title='��' ORDER BY a_id LIMIT 1
执行错误: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Deprecated: Function ereg() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 54

Deprecated: Function ereg() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 51

Deprecated: Function ereg_replace() is deprecated in /www/wwwroot/www.kaoziba.com/SpeedPHP/Misc/notice.php on line 54

/www/wwwroot/www.kaoziba.com/SpeedPHP/Drivers/mysql.php on line 62

57.

58.


        $this->arrSql[] = $sql;

59.


        if( $result = mysql_query($sql, $this->conn) ){

60.


            return $result;

61.


        }else{

62.


            spError("{$sql}<br />执行错误: " . mysql_error());

63.

64.

65.

66.

/**

67.


     * 返回影响行数

/www/wwwroot/www.kaoziba.com/SpeedPHP/Drivers/mysql.php on line 26

21.

22.


     * @param sql  执行的SQL语句

23.

*/

24.


    public function getArray($sql)

25.

26.


        if( ! $result = $this->exec($sql) )return array();

27.


        if( ! mysql_num_rows($result) )return array();

28.


        $rows = array();

29.


        while($rows[] = mysql_fetch_array($result,MYSQL_ASSOC)){}

30.


        mysql_free_result($result);

31.


        array_pop($rows);

/www/wwwroot/www.kaoziba.com/SpeedPHP/Core/spModel.php on line 103

98.


        }else{

99.


            $sort = "ORDER BY {$this->pk}";

100.

101.


        $sql = "SELECT {$fields} FROM {$this->tbl_name} {$where} {$sort}";

102.


        if(null != $limit)$sql = $this->_db->setlimit($sql, $limit);

103.


        return $this->_db->getArray($sql);

104.

105.

/**

106.


     * 过滤转义字符

107.

108.


     * @param value 需要进行过滤的值

/www/wwwroot/www.kaoziba.com/SpeedPHP/Core/spModel.php on line 65

60.


     * @param sort    排序，等同于“ORDER BY ”

61.


     * @param fields    返回的字段范围，默认为返回全部字段的值

62.

*/

63.


    public function find($conditions = null, $sort = null, $fields = null)

64.

65.


        if( $record = $this->findAll($conditions, $sort, $fields, 1) ){

66.


            return array_pop($record);

67.


        }else{

68.


            return FALSE;

69.

70.

/www/wwwroot/www.kaoziba.com/modules/index/article.php on line 64

59.

60.


    function show(){

61.


        $id = $this->spArgs("a_id") ? $this->spArgs("a_id") : $this->spArgs("id");

62.


        if(!$id){

63.


            $title = $this->spArgs("title");

64.


            $article = $this->_article->find("a_title='$title'");

65.


            $id = $article[a_id];

66.

67.


        $conditions = "a_id=".$id;

68.


        $this->_article->incrField($conditions, "a_click");

69.


        $result = $this->_article->find($conditions);

/www/wwwroot/www.kaoziba.com/SpeedPHP/spFunctions.php on line 21

16.


    if(!is_object($handle_controller) || !method_exists($handle_controller, $__action)){

17.


        eval($GLOBALS['G_SP']["dispatcher_error"]);

18.


        exit;

19.

20.


    // 路由并执行用户代码

21.


    $handle_controller->$__action();

22.


    // 控制器程序运行完毕，进行模板的自动输出

23.


    if(FALSE != $GLOBALS['G_SP']['view']['auto_display']){

24.


        $__tplname = $__controller.$GLOBALS['G_SP']['view']['auto_display_sep'].

25.


                $__action.$GLOBALS['G_SP']['view']['auto_display_suffix']; // 拼装模板路径

26.


        $handle_controller->auto_display($__tplname);

/www/wwwroot/www.kaoziba.com/index.php on line 39

34.

*/

35.

36.


$spConfig['view']['config']['template_dir'] = APP_PATH.'/template/'.$tpl_dir;

37.


require(SP_PATH."/SpeedPHP.php");

38.


import(APP_PATH.'/modules/index/bsController.php');

39.


spRun();

SELECT * FROM tab_article WHERE a_title='������������' ORDER BY a_id LIMIT 1执行错误: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

SELECT * FROM tab_article WHERE a_title='��' ORDER BY a_id LIMIT 1
执行错误: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='