Binary columns in database

It depends on the specific field and RDBMS engine. In general binary column definitions should be avoided with ORM.

This is what I use for MySQL column defined as BIT.

        $query = 'SELECT *, BIN(Active + 0) AS Active FROM VIDEOS WHERE Active = ? ORDER BY ClipID DESC LIMIT 10';
        $result = $this->db->query($query, [1]);
        $result->setFetchMode(\Phalcon\Db::FETCH_OBJ);
        $res = $result->fetchAll();

and how to write a Binary?

 \PDO::PARAM_LOB

in:

    return (bool)$this->connection->execute(
            $sql,
            [
                'collection' => $this->collection,
                'name' => $name,
                'data' => $this->encode($data)
            ],
            [
                'collection' => \PDO::PARAM_STR,
                'name' => \PDO::PARAM_STR,
                'data' => \PDO::PARAM_LOB
            ]
        );

Is not work.!!!!