Tuesday, February 18, 2014

Problem with encoding when reading in the mySql

Hi,

When I read data by cakephp 2.4.0. the function myModel->query(sqlString) returns wrong character set. Something like this: "é kÄ¾ÃºÄ e k výkla"
I think all is set to utf8, class DATABASE_CONFIG too:

class DATABASE_CONFIG {
    public $default = array(
        'datasource' => 'Database/Mysql',
        'persistent' => false,
        'host' => 'localhost',
        'login' => 'xxx',
        'password' => 'xxx',
        'database' => 'xxx',
        'prefix' => '',
        'encoding' => 'utf8'
    );
}

When I read data from database by pure php, data are ok.
When this same cakephp code reads from another mysql server (under windows) data are ok.

Can anyone advice me?
Thanks
-Samuel

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.

No comments: