MySQL connection encoding

If propel has a configuration option, we can add this to the databases.yml.

there is a propel option.

but setting this propel.database.encoding = utf-8 in propel.ini

still returns 'latin1' for print mysql_client_encoding ();

propel.ini settions are build time only and conversions to/from charset are done with iconv

I close this bug since it is more a Propel issue than a symfony one.

Following the discussion on this post, reopened this ticket. It would really be great to have a workaround in symfony. I consider this issue is quite serious as data is corrupted in the database if certain standard system configurations are met.

It is a creole issue. There is nothing I can do in symfony.

http://creole.phpdb.org/trac/ticket/13

Please, talk to the creole devs.

Pointer: A workaround can be found here: http://www.symfony-project.com/snippets/snippet/37

Yesterday Creole 1.1.0 with encoding support for mysql has been released.

It would be nice to have this option added to databases.yml now.

See http://creole.phpdb.org/trac/changeset/48

(In [2136]) added encoding parameter to database.yml (closes #203, #944)

encoding parameter did't set before, so always null;

epaulin@yinhm:symfony$svn diff lib/database/sfPropelDatabase.class.php
Index: lib/database/sfPropelDatabase.class.php
===================================================================
--- lib/database/sfPropelDatabase.class.php     (revision 2161)
+++ lib/database/sfPropelDatabase.class.php     (working copy)
@@ -70,6 +70,7 @@
       $this->setParameter('username', $params['username']);
       $this->setParameter('password', $params['password']);
       $this->setParameter('port',     $params['port']);
+      $this->setParameter('encoding',  $params['encoding']);
     }

     self::$config['propel']['datasources'][$this->getParameter('datasource')] =

(In [2172]) fixed MySQL connection encoding (closes #203 - patch from epaulin)