AW: [fw-general] Zend JSON umlaut (special chars)

[Stefan Gehrig]

Hi Andrei,

 

please make sure that your data is UTF-8 encoded.

Either run your retrieved data through utf8_encode() or make sure that the
result returned from the database is UTF-8.

When using MySQL (Zend_Db_Adapter_Pdo_Mysql) you can easily do this by
adding a 'driver_options' key to your database configuration with

'driver_options' => array(

    PDO::MYSQL_ATTR_INIT_COMMAND => “SET NAMES ‘utf8’”

)

 

Best regards

 

Stefan

 

Von: Andrei Iarus [mailto:poni1...@yahoo.com] 
Gesendet: Samstag, 11. April 2009 00:26
An: Zend Framework
Betreff: [fw-general] Zend JSON umlaut (special chars)

 


Hello there,

 

I have a problem with encoding an array retrieved from DB. I use this:

 

$states = Zend_Registry::get('db')->fetchAll('SELECT state_id AS id, name_en
AS name FROM core_states WHERE country_id = ?',
$this->_getParam('countryId'));

echo Zend_Json::encode($states);

 

If the name_en field has an umlaut (from a german state), the encoding will
return null. So 

[{"id":"124","name":null},{"id":"125",...]

is an example (with only the first element), but when I var_dump the encoded
var, I get

array(16) {
  [0]=>
  array(2) {
    ["id"]=>
    string(3) "124"
    ["name"]=>
    string(17) "Baden-Württemberg"
  }
...

 

I see the last version (1.7.8). Did you encounter the same problem?

 

Thank you