Q:

Symfony 1.4 propel schema.yml: how to set utf8 charset, utf8_collate_ci as collation?

Everything is utf8 where it can, still when I see the table, I see the charset is latin and the collation is latin_swedish_ci. I want to set utf8 and utf8_collation_ci. How?

A:

in your databases.yml you can set : 
all:
  doctrine:
    class: sfDoctrineDatabase
    param:
      dsn: 'mysql:host=localhost;dbname=mydb'
      username: myusername
      password: mypassword
      attributes:
        default_table_charset: utf8
        default_table_collate: utf8_general_ci

