How to set charset to UTF-8 in a Zend application?
Have you set the following, to fetch data from MySQL as utf8?
resources.db.params.charset = "utf8"
It is necessary to do three things to get correct characters displaying correctly:
- Save PHP/HTML files in utf8 encoding
- Fetch data from MySQL as utf8
- Send the right content-type / charset header or use a meta tag
Further information in Rob Allen's article.
I had the same problem while using the Doctrine2 module in my Zend Framework 2 application. Explicitly setting the character set for my Doctrine2 module solved the issue...
Just add 'charset' => 'utf8'
to your doctrine connection parameters:
'params' => array(
'host' => 'localhost',
'port' => 'yourport',
'user' => 'username',
'password' => 'password',
'dbname' => 'yourdatabase',
'charset' => 'utf8',
)
Might also work for your normal database connection. Add 'charset=utf8'
to the connection string:
'db' => array(
'driver' => 'Pdo',
'dsn' => 'mysql:host=$localhost;dbname=$yourdatabase;charset=utf8',
'driver_options' => array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''
)
),
Have you tried also setting the headers to utf8? Usually in php i do it this way
header ('Content-type: text/html; charset=utf-8');
in your case i think you must use something different. i've taken this example from Zend Framework documentation maybe you should use something different, i'm no expert of Zend_Framework
// Within an action controller action:
// Set a header
$this->getResponse()
->setHeader('Content-Type', 'text/html')
->appendBody($content);
If you set headers, meta and encoding it should work (from your code it seems to me you are only setting meta and encoding)
(look at this question to understand what i mean, the answer from Berry Langerak: PHP Display Special Characters)
EDIT - i also found another example in this article where it sets the header for a controller, take a look at it,maybe this is what you are looking for : http://www.chris.lu/en/news/show/4d56d0ecb058c/
This part might be what you are looking for:
protected function _initFrontControllerOutput() {
$this->bootstrap('FrontController');
$frontController = $this->getResource('FrontController');
$response = new Zend_Controller_Response_Http;
$response->setHeader('Content-Type', 'text/html; charset=UTF-8', true);
$frontController->setResponse($response);
$frontController->setParam('useDefaultControllerAlways', false);
return $frontController;
}