Accent php - Firebird

Question

I’m making a web module for an old system that uses Firebird. I made the connection using PDO, but when I do a query using some special character it does not return results. If you don’t use a special character, the consultation works perfectly.

He can read the names that use special character and show, but I am not able to consult with special parameters.

I am also looking for the solution through ibase_connect.

The goal is to perform searches with "ç" in Firebird through PHP

Answer 1

$pdo = new PDO('pgsql:host=hostname;dbname=dados', 'user', 'pass');

$pdo->exec("SET NAMES 'UTF8'");