I was able to set the collation on a mysql database through YAML using
the attributes default_table_charset and default_table_collate.
Here's how my config/database.yml file looks like:
all:
doctrine:
class: sfDoctrineDatabase
param:
dsn: 'mysql:host=yourHostServer;dbname=yourDbName'
username: yourUserName
password: yourUserPassword
attributes:
default_table_type: INNODB
default_table_charset: utf8
default_table_collate: utf8_general_ci
Hope it helps.
On Sep 9, 5:28 am, Aleš <ales.sark...@gmail.com> wrote:
> How can i set the default collation in the sandbox with the YAML
> config:
> $em->getEventManager()->addEventSubscriber(new
> MysqlSessionInit('utf8','utf8_unicode_ci'));
>
> I found somewhere it should be like this:
>
> doctrine.dbal:
> dbname: s2test
> user: root
> password: pass
> options:
> collation: utf8_unicode_ci
> charset: utf8
>
> But it doesn't work.
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
