Subject RE: [firebird-support] Firebird 30 char fieldname limit?
Author Alan McDonald
> G'day,
>
> Is there a way to get more than 30 characters in the fieldname
> returned from a SELECT query?
>
> I'm running into this limitation using queries built from both
> IBExpert and within PHP and it's ADOdb abstraction library.
>
> The queries are executing okay, it's just the result set fieldname
> that is being truncated to 30 chars.
>
> Hopefully there a config option for this somewhere? Bueller?
>
> Have checked docs and google with no luck so far.
>
> Am using Firebird 1.5 RC8 on WinXP with latest patches,
> but will also be running on Linux in production.
>

I thought the limit was actually 32 - have a look in the system tables, but
AFAIK there is no config setting - it's a system table limit to set many of
the metadata names as varchar(32)
Alan