Mysql-Html string problem

Question

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?

Imre L · Accepted Answer · 2011-08-01 22:25:09Z

1

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)

answered Aug 1, 2011 at 22:25

Imre L

6,29126 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mokus Over a year ago

This is hepl a little bit, before I had two question marks, now I have only one:)

Mokus Over a year ago

I have figured out the problem, before the upload I'm executing this ( "SET NAMES 'utf8'");

Ruslan Polutsygan · Accepted Answer · 2011-08-01 21:54:58Z

1

Maybe your files are in wrong encoding? I was having similar problem whan my files were in CP-1251, all data were in UTF-8 and I needed to show danish symbols. Changing file-encoding has solved this problem. Try, maybe it will be helpfull for you too.

answered Aug 1, 2011 at 21:54

Ruslan Polutsygan

4,4612 gold badges28 silver badges38 bronze badges

2 Comments

Mokus Over a year ago

Yes, I know this problem, but beside the mysql data, I also printing out other data which are good.

Ruslan Polutsygan Over a year ago

Are you using any string php functions(strpos, str_replace, strcmp, sustr, etc)? As far as I know they don't work with ust8-strings. Try to use mb_-prefixed function for string manipulations(functions from php extention called mb_string).

Collectives™ on Stack Overflow

Mysql-Html string problem

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related