Mysql-Html字符串问题

发布于 2024-11-27 11:39:32 字数 688 浏览 0 评论 0原文

我有一张表，在 joomla 中我得到以下数据：在此处输入图像描述

1. fc k��ln - vfl wolfsburg
germany 1. bundesliga

所以我创建了一个测试页面，我将标头设置为 utf-8，一切都很好，我收到了想要的数据：

Array
(
    [0] => Array
        (
            [id] => 4e36e64eb34d2
            [team1] => 1. FC Köln
            [team2] => VFL Wolfsburg
            [league] => Germany 1. Bundesliga
            [sport] => Soccer
            [time] => 2011-08-06 15:30:00
        )

)

我还检查了 joomla 标头，它包含字符集：

<meta http-equiv="content-type" content="text/html; charset=utf-8" />

我做错了什么？

原文

I have a table, in joomla I'm getting the following data:
enter image description here

1. fc k��ln - vfl wolfsburg
germany 1. bundesliga

so I created a test page, I set up the header as utf-8, and everything was fine, I received the wanted data:

Array
(
    [0] => Array
        (
            [id] => 4e36e64eb34d2
            [team1] => 1. FC Köln
            [team2] => VFL Wolfsburg
            [league] => Germany 1. Bundesliga
            [sport] => Soccer
            [time] => 2011-08-06 15:30:00
        )

)

I also check the joomla header and it's contains the charset:

<meta http-equiv="content-type" content="text/html; charset=utf-8" />

What am I doing wrong?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

西瑶 2024-12-04 11:39:32

你的数据库连接必须设置为UTF8

在includes/database.php文件中大约第102行（下面第二行）处设置mysql连接字符集

$this->_table_prefix = $table_prefix; 
//@mysql_query("SET NAMES 'utf8'", $this->_resource); // THIS IS THE LINE TO UNCOMMENT 
$this->_ticker = 0; 
$this->_og = array();

当然你表中的数据必须是utf-8，检查这一点。

其他可能要检查的事情是您的浏览器是否将此页面视为 utf8（在 firefox 中：查看 -> 字符编码）

your database connection has to be set UTF8

set the mysql connection charset in includes/database.php file at about line 102 (second line below)

$this->_table_prefix = $table_prefix; 
//@mysql_query("SET NAMES 'utf8'", $this->_resource); // THIS IS THE LINE TO UNCOMMENT 
$this->_ticker = 0; 
$this->_og = array();

Ofcourse your data in table has to be utf-8, check this.

Other possibible thing to check is if your browser sees this page as utf8 (in firefox: View->character encoding)

回复收藏 0 原文