Mysql UFT8 not working on Phalcon Micro

Question

Mysql UFT8 not working on Phalcon Micro

Felipe Barros Oct '15

Created Oct '15	Last Reply Oct '15	Replies 3	Views 547	Votes 0

Felipe Barros 688

Oct '15

Hi, I've already made a lot of research and tried many configurations but still get the same error so here is the case;

I have a phalcon MVC app running on a database and everything works fine it can retrive all data from in UTF-8 with no problem but I'm writing a micro app that retrives data from the same database and it can't ready special caracteres.

I tried: on my services.php and config,php files

"options" => array( \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8' )

and also 'charset'=> 'utf8'

Tried this as well:

/**

Database connection is created based in the parameters defined in the configuration file */ $di->set('db', function () use ($config) { return new DbAdapter(array( 'host' => $config->database->host, 'username' => $config->database->username, 'password' => $config->database->password, 'dbname' => $config->database->dbname, 'charset' => $config->database->charset )); });

but seams phalcon is not reading de services.php file.

Any help would be appreciated.

Thanks in advance.

Izo · Answer 1 · 2015-10-28T05:56:15-07:00

dont use the config, just hardcode it inside

$this->di->set('db', function() use ($config) {

            $class = new \Phalcon\Db\Adapter\Pdo\Mysql([
                'host' => $config->database->host,
                'username' => $config->database->username,
                'password' => $config->database->password,
                'dbname' => $config->database->dbname,
                'port' => '3306',
                'charset' => 'utf8',
                "options"  => [
                    \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
                    \PDO::ATTR_PERSISTENT => true,
                    \PDO::ATTR_EMULATE_PREPARES => false,
                    \PDO::ATTR_DEFAULT_FETCH_MODE  =>  \PDO::FETCH_ASSOC,
                    \PDO::ATTR_STRINGIFY_FETCHES => false
                ]
            ]);

            return $class;
        }, true);

Felipe Barros · Answer 2 · 2015-10-28T06:01:43-07:00

Hi @Izo thanks for prompt response, I've just tried it and didn't work for me I don't know why but seams like it is not reading my services file because if I remove all paremeters from connection from the file it still connecting to the database.

dont use the config, just hardcode it inside

$this->di->set('db', function() use ($config) {

           $class = new \Phalcon\Db\Adapter\Pdo\Mysql([
               'host' => $config->database->host,
               'username' => $config->database->username,
               'password' => $config->database->password,
               'dbname' => $config->database->dbname,
               'port' => '3306',
               'charset' => 'utf8',
               "options"  => [
                   \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
                   \PDO::ATTR_PERSISTENT => true,
                   \PDO::ATTR_EMULATE_PREPARES => false,
                   \PDO::ATTR_DEFAULT_FETCH_MODE  =>  \PDO::FETCH_ASSOC,
                   \PDO::ATTR_STRINGIFY_FETCHES => false
               ]
           ]);

           return $class;
       }, true);