Subject | RE: [firebird-support] Firebird 30 char fieldname limit? |
---|---|
Author | Alan McDonald |
Post date | 2004-02-17T05:08:06Z |
> G'day,I thought the limit was actually 32 - have a look in the system tables, but
>
> 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.
>
AFAIK there is no config setting - it's a system table limit to set many of
the metadata names as varchar(32)
Alan