Hello.

I am using sfDoctrine and I need to connect to Oracle with charset defined in
PDO's dsn.

The working pdo connection identifier should look like this:
oci:host=localhost;port=1521;dbname=XE;charset=AL32UTF8

I don't know, what is the best way to get charset into the string.

I found, that there is a method Connection::setCharset, which I can't use,
because oracle hasn't any possibility to change charset after establishing a
connection.

Because I am using sfDoctrine, I do not find a way how to bypass my own PDO
instance into Doctrine_Manager.

Therefor I crate a patch for Manager.php (attachement), but I don't know, if
this is the right way how to do it.

Thank's for any proposals
--
Miloslav Kmet

Manager.php.patch < 1K Download

You can specify PDO style dsn to Doctrine.

Doctrine_Manager::connection(array('driver:dbname=database_name;host=localh ost',
'username', 'password'));

And in databases.yml in symfony it is.

all:
  doctrine:
    class:          sfDoctrineDatabase
    param:
      dsn:          driver:dbname=database_name;host=localhost
      username:     username
      password:     password

On Thu, Sep 18, 2008 at 3:20 AM, Miloslav Kmeť <miloslav.k...@gmail.com>wrote: