Subject Re: Lengthen RDB$FIELDS.RDB$FIELD_NAME?
Author Adam
--- In firebird-support@yahoogroups.com, "Steve Miller"
<Steve_Miller@...> wrote:
>
> I am new to Firebird, and I am trying to port a database from SQL
> Server to Firebird. The SQL Server database has field names as long as
> 37 characters. RDB$FIELDS.RDB$FIELD_NAME has 31 characters, so I am
> getting an error about string truncation.
>
> The simplest solution would be changing the length of the column, but
> what are the dangers of that?

Unfortunately, that is not going to work. I agree it is an annoying
limitation, but not too many others seem to think so.
http://tracker.firebirdsql.org/browse/CORE-749

> Am I going to be forced to change the name through tens of thousands
> of lines of code?

Yes.

Adam