(PECL PDO_FIREBIRD >= 0.1.0)
PDO_FIREBIRD DSN — Connecting to Firebird databases
The PDO_FIREBIRD Data Source Name (DSN) is composed of the following elements:
The DSN prefix is firebird:
.
dbname
The name of the database.
charset
The character set.
role
The SQL role name.
dialect
The dialect of the database; either 1
or 3
.
If not specified, the dialect defaults to 3
.
Available as of PHP 7.4.0.
Example #1 PDO_FIREBIRD DSN example with path
The following example shows a PDO_FIREBIRD DSN for connecting to Firebird databases:
firebird:dbname=/path/to/DATABASE.FDB
Example #2 PDO_FIREBIRD DSN example with port and path
The following example shows a PDO_FIREBIRD DSN for connecting to a Firebird database using hostname port and path:
firebird:dbname=hostname/port:/path/to/DATABASE.FDB
Example #3 PDO_FIREBIRD DSN example with localhost and path to employee.fdb on Debian system
The following example shows a PDO_FIREBIRD DSN for connecting to a Firebird database employee.fdb using localhost:
firebird:dbname=localhost:/var/lib/firebird/2.5/data/employee.fdb
Example #4 PDO_FIREBIRD DSN to connect to a dialect 1 database
The following example shows a PDO_FIREBIRD DSN for connecting to a Firebird database test.fdb which has been created using dialect 1. This is only supported as of PHP 7.4.0.
firebird:dbname=localhost:/var/lib/firebird/2.5/data/test.fdb;charset=utf-8;dialect=1