I have to read records from a firebird 2.5.2 DB
I'm using PDO with the firebird driver
new \PDO("firebird:dbname=server/3050:C:\DB\DBName.fdb", 'USERNAME', 'password');
I don't run the DB, I only have read access to it and, honestly, I don't know much about firebird itself. But I just have to run some simple SELECT queries for import purposes.
The problem is that I need to use very long alias names (>31 chars) like
SELECT ID AS I_KNOW_THIS_IS_A_VERY_VERY_VERY_LONG_ALIAS_NAME FROM TABLEX
now when I run my query in PHP through PDO the name is beeing truncated to 31 chars and the recordset is like
[
(int) 0 => [
'I_KNOW_THIS_IS_A_VERY_VERY_VERY' => '1'
],
(note that the query is correctly executed without errors)
I read that firebird 3 has a 31 bytes limitation for columns names but not firebird 2.5
In fact when I run the same query in a client (DBeaver with jdbcb) I have no problems with the aliases
So it seems to me that is a limitation in PDO and not in firebird.
Is there something to do to resolve this issue? (other than using shorter aliases, of course)
