开发者

Font problem in Joomla

开发者 https://www.devze.com 2023-03-24 04:11 出处:网络
I have a table, in joomla I\'m getting the following data: 1. fc k��ln - vfl wolfsburg germany 1. bundesliga

I have a table, in joomla I'm getting the following data:

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] =开发者_StackOverflow中文版> 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? Do I need some extra commands before I'm fetching the data?


DISCLAIMER : I do not use Joomla

This is really a Joomla Problem not a MySQL Problem. By any chance, are you using Joomla 1.0 ?

Here is something showing in the Joomla Documentation how to activate the MySQL Query SET NAMES using utf8.

You may also need to play with the collation setting within the DB Connection

Here are the default settings for MySQL 5.5.12 running in Windows 7

mysql> show variables like 'collation%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database   | latin1_swedish_ci |
| collation_server     | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)

mysql> show variables like 'char%';
+--------------------------+---------------------------------+
| Variable_name            | Value                           |
+--------------------------+---------------------------------+
| character_set_client     | latin1                          |
| character_set_connection | latin1                          |
| character_set_database   | latin1                          |
| character_set_filesystem | binary                          |
| character_set_results    | latin1                          |
| character_set_server     | latin1                          |
| character_set_system     | utf8                            |
| character_sets_dir       | C:\MySQL_5.5.12\share\charsets\ |
+--------------------------+---------------------------------+

Try setting the character set and collation variables within the session or set this in my.cnf and restart mysql

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号