Symfony1.2 is not binding special characters correctly

76 Views Asked by At

I need to insert special characters in Oracle database.

My code:

$api_input['forename']='jéíóú';
$stmt->bindParam(':forename',$api_input['forename'], PDO::PARAM_STR | PDO::PARAM_INPUT_OUTPUT, 4000);

database.yml

 dev:
 propel:
  param:
 classname:  DebugPDO
 queries: { value: 'SET NAMES UTF8;' }
 host:       ''
 dsn:        'oci:dbname='
 username:   **
 password:   **
 sessions_db:
 class:        sfPDODatabase
 param:
 classname:  DoctrinePDO
 dsn:        'oci:dbname='
 username:   **
 password:   **
 encoding:   utf8_encode
 collate: utf8_unicode
 charset: utf8
 persistent: false
 pooling:    false

But when accessing the same value in Oracle I receive :

jéíóú

I don't understand if I'm hardcoded value with special characters.

Then how the value is changed when accessing in Oracle procedure.

I have tried all settings but none of solutions work for me.

Why Symfony is changing the input with jéíóú instead of jéíóú?

I have consulted this link: http://oldforum.symfony-project.org/index.php/m/72587/

0

There are 0 best solutions below