Subject | Re: [firebird-support] Lengthen RDB$FIELDS.RDB$FIELD_NAME? |
---|---|
Author | Helen Borrie |
Post date | 2007-12-12T23:46:13Z |
At 10:26 AM 13/12/2007, you wrote:
./hb
>I am new to Firebird, and I am trying to port a database from SQLComplete corruption. Don't interfere with the system tables. Period.
>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?
>Am I going to be forced to change theYes. And if you want a long and happy life, use "legal" identifiers, rather than subject yourself to the lifelong burden of quoted identifiers.
>name through tens of thousands of lines of code?
./hb