I had some problem with sessions with utf-8 text when save some information to session. sfMySQLDatabase.class.php don't use: "SET NAMES". So I am add 2 patches.
1) sfMySQLDatabase.class.php.patch - add
@mysql_query("SET NAMES '{$encoding}'", $this->connection);
Using, [databases.yml]:
session:
class: sfMySQLDatabase
param:
dsn: 'mysql:dbname=demo;host=localhost'
database: demo
username: root
encoding: utf8 # read from here
password: root
hostspec: localhost
host: localhost
Using [factories.yml]:
all:
storage:
class: sfMySQLSessionStorage
param:
db_table: sessions
database: session
2) sfDatabaseSessionStorage.class.php.patch - can use "propel" connection:
Using [factories.yml]:
all:
storage:
class: sfPDOSessionStorage
param:
db_table: sessions
database: propel